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:
when `Offer Made` is not null and 'Offer Made` = 'Yes' then `1`
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)
A couple things:
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)