Best Of
Re: How to calculate best?
For the final calculation, you could try something like:
(SUM(CASE WHEN `Field` IN ('9','10') THEN 1 ELSE 0 END) -- Sum of 9 and 10
-
SUM(CASE WHEN `Field` IN ('9','10') THEN 0 ELSE 1 END)) -- Sum of all Other Values
/
COUNT(`Field`)
It's hard to be too sure without seeing more of the dataset, Could you post a few lines of the data?
Re: Single Value Card - No numeric abbreviations
@MarkSnodgrass Thanks Mark this helped me today!
Re: Toggle series in bar chart
@MichelleH @RobSomers extremely helpful, thank you for telling me about this feature!!
jrtomici
Re: Toggle series in bar chart
@jrtomici You can accomplish this by creating a variable with values for each type of calculation. Then you can create a beast mode based on which calculation type is selected in your variable control like the one below. This beast mode would then be used as the Value/Y-Axis in your card.
case when `Calculation Type` = 'Calculation A' then `Field A` when `Calculation Type` = 'Calculation B' then `Field B` end
More on variables here: https://domo-support.domo.com/s/article/7903767835031?language=en_US
Re: Toggle series in bar chart
@jrtomici You can look into using variables for this. Make the inputs 'Total A' and 'Total B', and then create a beast mode like:
case when 'Variable' = 'Total A' then 'Total A' (or beast mode calculation)
when 'Variable' = 'Total B' then 'Total B' (or beast mode calculation)
Re: Change default "No data in filtered range domo" message
@NateBI You can change the text you see when there is no data in the card under Chart Properties > General > No Data Message
Re: Roll up rows in table chart with similar fields
In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.
Re: Dropdown selector filter card not displaying all values
@jrtomici Do the same UID's appear in multiple rows? If so, that may be the issue. If for example, each UID appeared 10 times, then there's actually 190 "values" or rows and it's just showing the unique ones. I've seen that happen with dashboard filter cards. On your filter, if you use a count of UID in the Optional Group By field, that may fix your problem.
Re: Any Way to Report on Column Usage in Cards
@pstrand2 Yes, you would want to use the Card Fields with Beast Modes report from the Domo Governance Connector. This will tell you which cards use each field by dataset.