Hi There,
I'd like to create a beast mode so that my pie chart can create all the options.
I currently have a beast mode that has a true/false statement indicating which cells have been updated/not updated. I want to return the count of all the not updated as well as options A, B, and C. I'm not sure who to return all of those options as well as the not updated column.
CASE WHEN `option` = 'A' OR `option` = 'B' OR `option` = 'C' THEN 'UPDATED' ELSE 'NOT UPDATED' END
Return should =
A
B
C
NOT UPDATED.
Any help is much appreciated!