ST_Superman Domo Employee

#3 I have actually been asked to build something nearly identical to this dashboard multiple times. 🤮

@BMilner I would recommend joining this data in using a dataset view. These joins happen much faster than ETLs (near instant). The downside here would be that you would need to change any cards or content you have built to a new dataset.

@pauljames I would recommend some caution when showing a data last updated card. I often find that the datasets I'm building content on are the result of a magic or MySQL dataflow. This means that the dataset last updated is just providing details about when the dataflow was last run. It does not mean that the raw data was…

@Jessica that would show you the last 6 months, but if I change the date grain on the card to quarter it would not display that last 6 quarters.

@carthur Thanks for posting the desired output. It would be helpful to see what the actual data looks like in your dataset and what you want Domo to do with those values to populate the table. Any chance you could walk through an example with some data points that match the schema of your dataset? And how you would expect…

@Victoria_G1 From your first question, it sounds like you are trying to filter your dataset for null values. The issue here is that NULL does not equal anything (not even itself). If you want to filter for null values, I would create a beastmode: IFNULL(`ExtRR Market`, 'NULL') You can then filter by this field for the…

The summary number needs to be an aggregate function. I would recommend something like MAX(`TimeStampField`)

@shreeyab There is an extra space after your text for `Template Schedule Date `. Try removing that?

Can you try adding your Error Ratio calculation into the filter deny clause as well?

From your original data table, you could try something like this: sum(sum(DISTINCT Amount) fixed (by Member,OpptyID)) that gives me this

@ColinHaze Could you walk me through the math for Kinard Trucking for July that you are looking for? Do you want to see: (sum of Kinard for July) / (sum of Kinard for entire time period) (6.64) / (38.13) = ~17% or (sum of Kinard for July) / (sum of all carriers in July) (6.64) / (41.35) = ~16% Neither of these seem to get…

@A_Benincasa It would be helpful to understand what your data looks like. Could you let us know what columns in your dataset you want to use for the beastmode and what data type they are. It's also always helpful if you can walk through an example of what your data says and how you expect the beastmode to calculate.

@Marie_Serrano It looks like this alert was set on a card. Double check that the card does not have any filters set on it and confirm that there are no page filters that might be blocking this data on the page the card is located on. Also confirm that the summary number for the card is still set to what you are expecting.…

@phesson I believe that @jessdoe is on the right track here. The only thing that I would add to her code is an "ELSE 0" before ending the case statement. SUM(CASE WHEN Source = Location THEN ValueField ELSE 0 END)

The standard table card would allow you to use HTML to display a hyperlink. For more customization and options, you would probably need to investigate using a Domo Brick.

@ScottLeeds You need to use two aggregations for this to work. SUM(SUM(1)) over….

You can create a beastmode to flag certain dates and then select to either include or exclude those dates by adding the beastmode to the filter section.

I don't think beastmodes like the BETWEEN clause. Instead of: SUM(CASE WHEN Instrument Fiscal Year BETWEEN SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END)),1/(SEG PMKA CAGR End Period-SEG PMPK CAGR Start Period+1))-1 Try this: SUM(CASE WHEN Instrument Fiscal Year >= SEG PMPK CAGR Start…

I agree with @GrantSmith here. By using a fixed function, you should be able to check each date against all other dates coming through the filters. I would be curious to hear if this didn't work.

You can also combine the Tootip Field and the datalabel settings to display multiple values. However, the Pie value will only take the first into account.

This is a great idea +1

@NathanDorsch - is it because you are bringing in the same dataset multiple times?

@Backslash You can also use the chart properties to only label the datapoints for the line if that makes it cleaner. Another option to increase visibility would be to make the line thicker.

You can use the window function tile in Magic ETL. The function want to apply is LAG. This article gives more info, scroll down to the Rank & Window Tile section:

The brand kit options are fairly limited as well. Especially if you are wanting to make sure your dashboards are using your company preferred font.

You can do something like this with a Symbol + Stacked Bar chart You can also just view it for a single time period:

Yes, you can use the "Limit Rows" option to only show the number of items you want: In this example, only the top 10 products are displayed, but the total still shows the overall total for the time period

If you used a variable to set the current month and comparison month, then you could write a beastmode to get this calculation. But then the user would need to set those values when they view the card. (you can select a default value, but unfortunately the default can't be "current month". You would need to update the…

My understanding of the faceted bar chart is that it is good for combining charts that are measuring the same thing. In this case, it looks like you are measuring three different things at once. Since the top two are both looking at a count of opportunities or evals, those will probably work okay in a faceted chart, but I…

@domoexpert What type of visualization are you using? You can accomplish this with the Period over Period "Variance bar line" chart type: