Comments
-
Domo takes the first value and sets it as the line for this chart, so you could create a beast mode that ranks your KPI values. You could do something like this: CASE WHEN KPI = 'Website Cart Revenue' THEN 1 ELSE 2 END Then you can put this beast mode in the sorting section under the filter section. This should make the…
-
@ST_-Superman-_ Thanks for replying! Sadly, I deleted this card, so I'm not sure if I had anything in the sort section. I believe I removed everything in sort and chose specific columns to see if that was affecting it, since I know Domo won't display values grouped together if they have different values in the columns that…
-
@yentran Rank and dense rank use the window function, since Domo has to know how to group the data to perform the action of ranking. I believe window functions also have to be enabled for your Domo instance, so this might not work without that! For the window functions you typically use nested aggregate functions like…
-
@jaymin_63 Sadly, interactions don't work when you want to pass filters between cards and pages. I'm not sure if there's an easier way to do this, but I have been able to do this using a DDX Brick card. You can download DDX brick cards from the appstore in Domo, but they do require a little bit of JavaScript. The DDX brick…
