-
Calculating percent of total with values that count in multiple categories
I'm trying to develop a card for diverse business participation reporting. A single business may have multiple diversity classifications, and can be counted towards each. However, when we are looking at the total, we are looking at the total of distinct businesses. Example data: I want the card to have flexibility to…
-
Increase width in ComboBox component
Hi everyone! There is a way to increase width of ComboBox component to fill all extension of component? We use to show a description field where the length of text is much higher of the width of component
-
Can you combine 3 different columns in a pie chart?
Hi, I'd like to display the percentage of hard, medium and easy clients per PM in a pie chart. Is it possible to write a beast mode which can be used to combine the data? Thanks, Katie
-
Count how many Providers submit a range of cases
Hello, I am trying to segment our Providers by how many cases they submit. I have the formula below but I have something wrong. Ideally it will tell me how many Providers submit between 1 and 10 cases and 11 to 20 cases labeled them as Provider 1-10. This count will change throughout the year as they continue to submit…
-
Is it possible to set 12 complete months rolling date range?
I need to show completed months data only in a rolling 12 month cycle. Is this possible using date range filters? "Previous 12 months" includes current month which is incomplete and not required. I'm using between dates at the moment but this means I have to remember and change them the beginning of every month.
-
Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
I am building a dashboard that only shows completed months' worth of data. A few of the datasets I have though provide lagging data.... so for their specific cards, I just want to show data up until the prior month. I have created multi-value cards to show the MOM and YOY trends... they work when I have a completed dataset…
-
trends ratio for last 4 months
Hi, I created this card last year and it was working fine but as the year has changed and I'm working with 4 months data so 2 are now in last year Nov & Dec and 2 Jan & Feb this year. I tried working with Rank & Window function but running into problem with ASC and DESC My second pic in Yellow is how I want the results.
-
Card Drill
Hi guys! Do you know of a way to arrange the columns for the drill view? I know you can arrange the columns as a user and an admin within the drill view, but it does not save, so I am looking for a permanent solution. Thank you so much!
-
Dimension/metric selector for Cards
Hi, I wonder if there is a way to build a table card with an option to switch between dimensions/metrics to display. Let's say there are Revenue and Sold Items metrics, so I'd like to have a table card providing a break down by regions and an option for end users to choose which metric they want to see (I need just one).…
-
Original, historical dataset of recursive dataset still needed after 1st run?
Sometimes when we bring in a new data table into DOMO, we'll want, for example 5 year rolling history. And instead of pulling 5 years of data every day, we pull it once, feed it into an ETL output, then change the input of this ETL from the original 5 year dataset to the new output. then append a 1 day update. My question…
-
Can we use Partition by function with Case statement in beast mode?
Hi, I wanted to achieve the below screenshot data via beast mode. For each token id, whichever column (B,C,D) has non zero value, in the Merged column, I wanted to get that value. I tried case statement, say Case when A=0 and B=0 then C when A=0 and C=0 then B when B=0 and C=0 then A end This is not giving me the correct…
-
Heat map tables - Ranges per column
Hi, I have a table with multiple columns and different sets of numeric data and would like each column to have a heat map applied to identify the quintiles. I have tried a heat map table but it seems to apply a single range across all of the columns. Therefore the range spans the columns with the highest values down to the…
-
Colour Rules while comparing two columns.
Hi Team, Your support is highly appreciated in advance. Could you please advise/suggest how to apply colour rules based upon dynamic targets in 'Line Grouped Bar Chart'? Thanks Rabia
-
Is it possible to create a combo chart in the tiles?
I cannot create combo charts for the tiles (like you can in excel) where I can select the data for each axis, the data is automatically assigned (mostly to the wrong axis) or i cannot assign it at all. Is there a way round this? Can anyone help with this? Thanks
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
Can I nest a Select Distinct function in a beastmode?
Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a…
-
Create a card/text field that simply says the last month on a dashboard
I have a dashboard set up to review the last month. Is there a way to simply get a header or text box in the dashboard that identifies the last month? (each month, it will automatically change - so today, it should say February 2021 and on April 1, it will say March 2021).
-
Multiple Date Fields and Filters
I have one table with two date fields: date-1 and date-2. I would like to configure two filters such that filter-1 operates on date-1 and filter-2 operates on date-2. Is this possible? My experiments so far have yielded inconsistent results. I'm not sure how to control the mapping between dates and filters. Thanks!
-
Is there a way to show 0 values in line graphs?
Hello! I am looking for a way to continuously graph data, even when there are 0 values. When creating cards, I see breaks in line graphs when there is NULL data. Any ideas?? Thanks, Keirsten
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
Remove weekend days from calculations
Hi, I'd like to remove weekend days from calculating on time data. For example - 2 day turnaround to be met. Issued on Mon but started on Friday so would meet target but at moment is looking like 3 days. Could anyone help me with a beastmode for doing this - I have an opened and closed date. Thanks, Katie
-
Summary Number - "show more options" drop down is not displaying
When I click the drop down of the summary number in the analyzer the "show more options" tab is not showing up under "No Summary Number" Does anyone know the problem or how to resolve? Thanks
-
Grouped Bar - Hiding bars at dashboard view
I have a Grouped Bar card. If you go into card view, you can click on the name of the bars in the legend to hide/show them. However, from the dashboard view, clicking a bar name in the legend doesn't do anything. From the dashboard view, is there anyway to hide specific columns? Could it be done through a filter card, or…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
How can thousand separators be built into a concat() statement in a beast mode for a custom summary?
I found Creating a Custom Summary Number in the Knowledge base on https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms. I have built a custom summary number with the below beast mode that results in "75740929.28 Part Sales Net - February" Is there html code or…
-
How to ensure data for each month gets displayed in one row in this table chart instead of2rows
Beast mode used Approved Shifts = CASE WHEN `Approved` = 1 THEN SUM(`Total Charge`) ELSE 0 END Unapproved Shifts = CASE WHEN `Approved` = 0 THEN SUM(`Total Charge`) ELSE 0 END ST = SUM(`Total Charge`) Kindly advise what could be done to rectify it. Thanks
-
How to break up a page
Is there an easy way to break up a page when the content gets too long (which prevents me from exporting into powerpoint/pdf)?
-
Issues with cutoff characters at top of series for scatter chart
I've built a scatter chart and am having an odd issue with some weird noise at the top of my legend... This appears to be the result from putting a Tooltip value for data labels. And it makes the chart look very amateurish. Can anyone advise on this? See screenshots below. The first shows the issue I'm having... And this…
-
Adding comments in Beastmode calculations
This is a stupid question... but how do I write comments in Beast Mode calculations?
-
Survey - Count the answers.
If I have a survey and user can choose multiple answers and also have the choice to write. How can I count every option that the user has selected. Results should be like this. Red 3 Blue 2 Green 1 Orange 1 Pink 1 Yellow 1