Beast Mode not selectable in Summary Number

Reply
Highlighted
White Belt

Beast Mode not selectable in Summary Number

I have the Beast Mode code below using a CASE statement and it is populating the column Review CI.  I want to count the number of "Yes" results (or In Two) in the column and display in the Summary number.  I am not able to select Review CI when choosing Use all values.  Any assistance would be helpful and much appreciated.

 

Michael

 

(CASE when CASE
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'Yes' AND `InAD` = 'Yes' THEN 'In All'
WHEN `InKACE` = 'No' AND `InMcAfee` = 'Yes' AND `InAD` = 'Yes' THEN 'In Two'
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'No' AND `InAD` = 'Yes' THEN 'In Two'
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'Yes' AND `InAD` = 'No' THEN 'In Two'
ELSE 'In One'
END = 'In Two' then 'Yes' else 'No' end)


Accepted Solutions
Highlighted
Red Belt

Hi @GuitarMan2020 

 

Summary numbers only support beast modes which are aggregates (MIN, MAX, SUM, AVG etc). You could wrap your CASE statement in either a MIN or MAX depending on the logic you require. If any record has 'Yes' and the end result should be 'Yes' then use MAX. If any record has 'No' and the end result should be 'No' then use MIN. (This works because of alphabetical sorting).



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post


All Replies
Highlighted
Red Belt

Hi @GuitarMan2020 

 

Summary numbers only support beast modes which are aggregates (MIN, MAX, SUM, AVG etc). You could wrap your CASE statement in either a MIN or MAX depending on the logic you require. If any record has 'Yes' and the end result should be 'Yes' then use MAX. If any record has 'No' and the end result should be 'No' then use MIN. (This works because of alphabetical sorting).



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.