Compare previous period to current in one row in table

[maryna_hubska]

Hello!

I need to visualise current and previous period in one row. 

2022-Q4 --- Column 1 --- Column (LFL) (for the 2021-Q4)

[AronC]

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.

[vinieme12]

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

[maryna_hubska]

Thank you, but I need solutin in general. Because it is possible to compare three days with previous three days, for example