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?
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))
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?
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!