Discussions
-
Custom Sort in bar charts
I followed Domo tutorial to create a custom sorting https://www.youtube.com/watch?v=QAKgsoRweQM but mine it's not working as I expect Firts I created a beast mode to transform my column like this: DATE_FORMAT(`Snapshot`,'%b') and then I needed to sorting by month so I try to create another beast mode like this: (CASE WHEN…
-
Sum if using Case When
How can I write this formula in an effective way? (CASE WHEN `Data`= 'Goal' THEN SUM(`Total`) ELSE 0 END) (CASE WHEN `Data`= 'Pipeline' THEN SUM (`Total`) ELSE 0 END) (CASE When `Data`= 'in P&L' THEN SUM (`Total`) ELSE 0 END) I need to create for every name, but it only works with the first one that I created
