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


  • 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?

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**