Beast Mode Embedded True/False

user01052
user01052 Member
in Magic ETL

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!

Best Answer

  • Jsun82
    Jsun82 Member
    Answer ✓

    If you use the formula, it should be populating the new beast mode field with a value.

     

    So, if the new column is called "Status", then for the cases when `option`

    'A' it stores a value of 'A'

    'B' it stores a value of 'B'

    'C' it stores a value of 'C'

    Anything else it should store 'Not Updated'

     

    And then when you graph it, it should tally those numbers.  If that doesn't work, you can insert:

    when `option` is null then 'Not Updated' as the additional case when line.

Answers

  • Jsun82
    Jsun82 Member

    I think I understand your question, but let me restate:

     

    You want a count of options A, B, C, and Not Updated to show on a chart.  If Option has a value A, B, or C, then it is considered updated.

     

    If so:

    case

    when `option` = 'A' then 'A'

    when `option` = 'B' then 'B'

    when `option` = 'C' then 'C'

    else 'Not Updated'

    end

     

    Then you can create your chart and sort by the item created above.

     

    Let me know if this produces your desired result.

     

     

  • user01052
    user01052 Member

    Thanks for the quick response!

    The problem I'm having is that the cells that are not updated are actually blank, so that's why they're not being counted. Is there a work around to also count the not updated cells?

     

     

  • Jsun82
    Jsun82 Member
    Answer ✓

    If you use the formula, it should be populating the new beast mode field with a value.

     

    So, if the new column is called "Status", then for the cases when `option`

    'A' it stores a value of 'A'

    'B' it stores a value of 'B'

    'C' it stores a value of 'C'

    Anything else it should store 'Not Updated'

     

    And then when you graph it, it should tally those numbers.  If that doesn't work, you can insert:

    when `option` is null then 'Not Updated' as the additional case when line.

  • user01052
    user01052 Member

    That worked perfectly! 

    Thanks so much!!!

Categories