Comments
-
since there are only 4 columns you can directly use a SQL dataflow to convert the data in the format you want and avoid any pivot stuff in ETL: select Account, 'A' as company, 'Prime_TV' as TV Category, A Prime_TV Revenue as value from Table union all select Account, 'A' as company, 'Premium_tv' as TV category, A…
-
This would be a great functionality addition as it would make the transition of dashboards into tabs much easier. Also is there a timeline for when we can expect this to be added?
-
Highlighting entire row doesn't seem to work in pivot tables. Only the column value is being highlighted
-
Apologies not adding this in the question, but I don't think I have window functions enabled in our Domo instance
-
Thanks David, I'l'l try that!
-
Any update on when this feature is going into Beta or if it's already released?
-
Got it thanks!
-
@ColemenWilson that's exactly what I'm doing in a couple of other places, but these specific cards have multiple x-axis in one of the cards and a single x-axis in the other card i.e. one card is at the granularity of Date X cateogory and other is just at Date granularity
-
But if I select the 'id' column, I want to sum for user-1 to be 5 and not 10(essentially the max of the values across both the lists for a user). If I just take sum aggregation directly, the result with be 10 for the first user and 20 for the second user but I have 5 and 10 respectively.
