Beast Mode If Statement

user02480
user02480 Member
in Magic ETL

Looking of help with a Beast Mode.  What is the Beast Mode for including in the "count" only "Yes" answers included on a domo synced Google Sheet.  I tried this:

 

case
when `Offer Made` is not null and 'Offer Made` = 'Yes' then `1`
else 0
end

 

But it was "invalid"

 

I have a vertical group bar chart that show the count of interviews completed and another color for offers made from that same interview.  I only want "Yes" responses to be included in the series.

 

Card:  X Axis: Office ---- Y Axis: Count of Interviews ----- Series: Offer Made (Offer made is either Yes, No, or Blank)

Best Answer

  • guitarhero23
    guitarhero23 Contributor
    Answer ✓

    Now, it would be hard to show the count of all interviews and also show only those that had offers on a single bar chart so if you're not already use something like a grouped bar using the above formula

     

    DojoHelp500.JPG


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**

Answers

  • guitarhero23
    guitarhero23 Contributor

    A couple things:

    • Remove the single quotes from around the 1. You want it to be the number one, to use for sums, not the string 1
    • You don't need to use both Offer Made is not null and Offer Made = Yes, if Offer Made = Yes that would imply it is not null.

     

    I'm not sure if it'll give you what you're looking for but this is how you can have that beastmode be valid

    (CASE 
    WHEN `Offer Made` = 'Yes' THEN 1
    ELSE 0
    END)

    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • guitarhero23
    guitarhero23 Contributor
    Answer ✓

    Now, it would be hard to show the count of all interviews and also show only those that had offers on a single bar chart so if you're not already use something like a grouped bar using the above formula

     

    DojoHelp500.JPG


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • user02480
    user02480 Member

    Thank you!  That worked perfectly.  Much appreciated.

Categories