Comparing previous week and current week data (without blending)

[BDutta]

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?

Thank You

[ArkadyZagdan]

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

[BDutta]

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

[nddi]

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

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.