How to display multiple summary number?

I have data based on quarter 1 and quarter 2. Can someone help me with the beast mode formula to display q1 and q2 values in summary number?

 

Thank you

Comments

  • adithya
    adithya ⚪️

    Create a beast mode calculation using concat()

    eg: concat('Q1',(case when quarter('date')=1 then 'value' else 0 end), 'vs', 'Q2', (case when quarter('date')=2 then 'value' else 0 end))

  • GrantSmith
    GrantSmith Indiana 🟤

    Hi @Pallavi

    Summary numbers must be aggregated so you'd need something like:

    CONCAT('Q1', SUM(CASE WHEN QUARTER(`date`)=1 THEN `value` ELSE 0 END), '  Q2', SUM(CASE WHEN QUARTER(`date`)=1 THEN `value` ELSE 0 END))
    

    This is under the assumption you're only viewing a single year at a time otherwise multiple years will get bucketed into the same quarter.


    Are you displaying (or giving the users the option to) multiple years?

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!