I am looking for a way to configure a dashboard in Looker Studio to display a series of charts based on a specific reference date.
What I want to achieve: I want to stack 7 individual line charts vertically, each representing one day of data. These 7 days should be the period leading up to a “Reference Date” (e.g., if the reference date is Jan 8th, I want to see individual charts for Jan 1st through Jan 7th).
Requirements:
-
Dynamic Filtering: The “Reference Date” should be selectable by the user via a Drop-down list or a Date range control.
-
Layout: 7 separate charts (or a configuration that looks like it) displayed vertically.
-
Logic: I need to find the best way to use Filter properties (OR/AND logic) to ensure each chart automatically updates to show “Reference Date - 1 day”, “Reference Date - 2 days”, and so on.
I have attached three images showing the available filter types and the current setup. I’m struggling with how to combine the date control input with specific offsets for each chart.
Does anyone have experience setting up this kind of “N-day lookback” layout using calculated fields or advanced filtering?
Please let me know if you need any further clarification. Thank you in advance!