Set Period Dates of 2 weeks to compare against

[lawalsey]

I would like to set set dates to compare the data   March 17th-31st'24 (Period 1) vs  March 17th-31st'24 (Period 2). How do i do that?

[Amanda-Google · Accepted solution]

Hi there - 

You can utilize AND and OR filters in your analysis to get down to the exact dates you need: https://cloud.google.com/looker/docs/and-or-filters-in-explores 

Also more detailed is a period over period analysis built out in Lookml

Let me know if this helps!