Hi,
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'**)
END
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. :)