Comparing previous week and current week data (without blending)

Looker Q&A Looker Studio
,
1

Hi
I am trying to comparing current week and previous week data here. I want my previous week data to be in the same row as my current week data without doing blending. I have applied the joining in my SQL query and pulled the data to looker studio. (coz blending in Looker is not allowing me to use data source parameters). Can anyone help me here to achieve the same?

BDutta_0-1721076922233.png
BDutta_0-1721076922233.png862×225 7.46 KB

Thank You

2

@BDutta
if your schema is correct then it should be simple (A less B) / A calculated field.

3

Hi @ArkadyZagdan ,
Thank You for your response, but here to get the column ‘A’(for current week value) and ‘B’ (previous week value) is a challenge for me. I can easily get the current week value(as shown in above screenshot as 'record count), but don’t know how to get previous week value at the same time.
any input on this?

Thank You
Barnana D

4

Looker studio has great feature called comparison date range. Below is the screen shoot.

nddi_0-1722405683570.png
nddi_0-1722405683570.png287×108 2.33 KB

For this to work you need date filter which the users can select the current week. In the comparison date range you can select the previous period.

It is great feature and to use without writing any code.