Question

YoY Comparison for selected date Range

  • 22 September 2020
  • 2 replies
  • 4708 views

Hi Everyone,

I have a requirement. I have a requirement where we have a date range filter in the dashboard and select a date range ,It should compare it with the previous year same date range .

For Example

I have selected 2020-08-01 to 2020-08-15.It should be compared with the same date rage ie 2019-08-01 to 2020-08-15.

Can any one help me on this .?


2 replies

Userlevel 4

Hello @akhilsai,


There are lots of Looker Community discussions on this matter:



Kind regards,

–Thomas

Hey @thomas_brittain


I got a solution for this from this Link.Period Over Period


There are around 8 solutions and the 7th solution worked for my requirement. I have to change the logic a bit .

Reply