Can we create a beast mode calculation with case statement for a value field?

I wanted to set the range of a value field like,

case when 'value' <=1 then '0-1 end

from this range, I wanted to see the count('dimensions'). I have tried this in beast mode, but not getting the correct count for each range.

Any help is appreciated

Thanks in advance

Salma

Answers

  • GrantSmith
    GrantSmith Indiana πŸ₯·

    @Salmas

    Its a bit difficult to help diagnose your issue without understanding what the current counts are and what you’re expecting them to be. Do you have any sample anonymized data you can post to help paint a better picture of your issue?



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

    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @Salmas


    what you CAN do is write

    case when value = 1 then 'between 0 and 1
    
    when value = 2 then between 1 and 2 ...
    
    end
    

    this will work fine because the CASE statement is evaluated BEFORE aggregation.

    what you CANNOT do is write:

    case when sum(amount) between 0 and 1 then ...
    

    because the case statement is evaluated AFTER aggregatioin. after aggregation, you already have a set number of rows. you could not add the resulting beast mode to your group by clause because that would require analyzer to run two subqueries (recalculate your results) twice.


    Jae Wilson
    Check out my Domo Training YouTube Channel

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