Question

YoY Comparison for selected date Range

  • 22 September 2020
  • 2 replies
  • 6394 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