Magic ETL

Magic ETL

Can you create a beastmode CASE when for values between two numbers?

I'm looking at influencers and their number of followers and want to group the data:

 

number of follower: 1-50000, 50000-100000, 100000-200000 and so on.

I was going to use the case when beastmode but cant find a between function to select the relevant numbers. Any help?

Tagged:

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Domo Employee
    Answer ✓

    Here you go:

    1. CASE WHEN `Followers` >= 0 AND `Followers` <= 9999 THEN 'Bronze'
      WHEN `Followers` >= 10000 AND `Followers` <= 99999 THEN 'Silver'
      WHEN `Followers` >= 100000 AND `Followers` <= 499999 THEN 'Gold'
      WHEN `Followers` >= 500000 AND `Followers` <= 1000000000 THEN 'Platinum'

      END

Answers

  • Domo Employee

    You sure can. Just modify this to your own use:

     

    1. CASE WHEN `followers` BETWEEN 1 AND 50000 THEN 'A'
      WHEN `followers` BETWEEN 50001 AND 100000 THEN 'B
      .....
      END

    Hopefully that's what youre looking for. If not, let me know and i'll try to help further.

     

    Sincerely,

    ValiantSpur

     

     **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • Hi! This doesnt seem to work, is there something else wrong with the beastmode calculation?

    CASE WHEN `Followers` BETWEEN 0 AND 9999 THEN 'Bronze'
    WHEN `Followers` BETWEEN 10000 AND 99999 THEN 'Silver'
    WHEN `Followers` BETWEEN 100000 AND 499999 THEN 'Gold'
    WHEN `Followers` BETWEEN 500000 AND 1000000000 THEN 'Platinum'

    END

     

  • Domo Employee

    What's the datatype for your `Followers` field? In the analyzer when you're doing the beastmode, what does the icon next to the field name look like? Is it a '123' like below?

    image.png

  • yes its '123' ?

  • Domo Employee
    Answer ✓

    Here you go:

    1. CASE WHEN `Followers` >= 0 AND `Followers` <= 9999 THEN 'Bronze'
      WHEN `Followers` >= 10000 AND `Followers` <= 99999 THEN 'Silver'
      WHEN `Followers` >= 100000 AND `Followers` <= 499999 THEN 'Gold'
      WHEN `Followers` >= 500000 AND `Followers` <= 1000000000 THEN 'Platinum'

      END
  • Hi, I'm also facing the same issue. I wanted to set the range of a metrics (datatype is '123'). Usually we show this metrics in a aggregated level (Sum). But the output of the beast mode is not showing correctly. Any solution for this?

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In