Beast Mode to replace null with 0
I have a pivot table that counts the "EventID" for each row of data, per person. Some people did not have activity so there is not a row of data to count.
I tried doing a beast mode for the "Values" field of the pivot table that replaces the null cells with a "0" so I can have the color settings make the cell dark red, but it is not working.
CASE WHEN COUNT(`EventID`) > 0 THEN COUNT(`EventID`)
ELSE 0 (** I also tried ELSE '0'**)
Is there a way to get a 0 in the cell without going back to the dataflow? It is just needed for this card.
I also tried using the color rules but when I left the "is" cell blank, all of the cells turned red, not just the empty ones.
Thank you for your help. :)
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board