Beast Mode to replace null with 0

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. :)

Comments

  • GrantSmith
    GrantSmith Indiana 🥷

    You can try and utilize the General - Fill Empty Data Cells with 0 settings on your pivot table to fill the blanks with a 0 and then try and compare to 0 for your color rule.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**