Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I need to visualise current and previous period in one row.
2022-Q4 --- Column 1 --- Column (LFL) (for the 2021-Q4)
Do you mind solving it backend?
If thats Ok, then you could just add an extra "Quarter table" that is keyed with the field Quarter.
I assume you have calendar table with the field Quarter. Than you create a new table like below
Orginal_Calendartable:
Quarter:
Q1-22
Q2-22
Q3-22
Q4-22
PrevQuarterTable:
Quarter: NewQuarterField
Q4-21, Q1-22:
Q1-22, Q1-22
Q1-22, Q2-22
Q2-22, Q2-22
Q2-22, Q3-22
Q3-22, Q3-22
Q3-22, Q4-22
Q4-22, Q4-22
Then you just use the NewQuarterField as Dimension a a set expression for the acutal month in one column and one set expression for the previous month in the second column.
Ofcourse you do not hard-code above. Above tables are only to show you the consept.
Instead of using Year-Quarter ie 2021-Q1,2022-Q1. field use only the Quarter field that has values Q1,Q2,Q3,Q4
The charts will naturally aggregate over common dimension values
Thank you, but I need solutin in general. Because it is possible to compare three days with previous three days, for example