I have a case where I have 3 dates one of my reports.
Item | Order Date | Dispatch Date | Delivery Date
Item1 | 25-11-2024 | 28-11-2024 | 01-12-2024
Item2 | 01-12-2024 | 02-12-2024 | 04-12-2024
This table has 3 date columns. What I am trying to is to add a date filter on my report, this can be a range or a single date.
Following the example table above, if I select, say 01-12-2024, I want to see two rows. Because this date is on Order Date of Item2 and Delivery Date of Item 1.
I could not find a way to do this. I’ve tried some combined fields but no avail ;(
I know its a bit complex care for Looker Studio but surely there must be a workaround.
I would appriciate any suggestions.
Interesting. So, date filters will only work on a single field. You’d have to find some way to get all three of these dates “into one field”, as it were. Of course, simply concatenating the dates wouldn’t work, because then the field wouldn’t register as a date anymore.
It seems like your goal is “tell me everything that happened on 01-12-2024 - orders, dispatches, and deliveries.” Do I have that right?
If that’s the case, I think what you’d want to do is start with a base table of dates, then use a blend to left join in your table three times - once per date. Then your table would look something like this:
Base Date | Order Date | Dispatch Date | Delivery Date | Item 01-12-2024 | 25-11-2024 | 28-11-2024 | 01-12-2024 | Item1 01-12-2024 | 01-12-2024 | 02-12-2024 | 04-12-2024 | Item2
Now, you should be able to filter on Base Date being 01-12-2024 and that would return both Item1 and Item2. It’s a pretty tricky workaround, but I think it would do what you’re looking for.