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: DAT…
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 …