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 .?
Hello @akhilsai ,
There are lots of Looker Community discussions on this matter:
- How to do Period-over-Period Analysis
- Pulling year over year data in a side by side format
- [Analytic Block] Flexible Period-over-Period Analysis
Kind regards,
–Thomas
2 Likes
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 .
1 Like