Add Two Date Filters

[hassanbassal]

Hi everyone, I was wondering if anyone could please help me with this Looker Studio request. I have this sheet where there are two important metrics: "Start Date" and "End Date" and I need to be able to put a filter so that, I can for example, see all tasks that started before April 1st 2024 and ended after April 30th 2024. Any ideas on how to do that?

[Justine_L]

Hi there! There are two steps to achieve this, creating date range controls, and creating a filter.

1. Create Date Range Controls:

• Start Date Control: Add a Date Range Control to your Looker Studio report.
  • In the control's settings, choose "Start Date" as the dimension.
  • Set the default value to a date before April 1st, 2024 (e.g., January 1st, 2024).
• End Date Control: Add another Date Range Control.
  • Choose "End Date" as the dimension.
  • Set the default value to a date after April 30th, 2024 (e.g., May 1st, 2024).

2. Create a Filter:

• Add a Filter: Click on "Add a filter" in your Looker Studio report.
• Conditions:
  • Start Date:
    • Select the "Start Date" dimension.
    • Choose the operator "Before or on."
    • Select the "Start Date" control as the value.
  • End Date:
    • Select the "End Date" dimension.
    • Choose the operator "After or on."
    • Select the "End Date" control as the value.
• Apply the Filter: Apply the filter to all charts and tables you want to be affected.

[Noegdip]

In response to the reply given where in Looker Studio can you choose a dimension for  date range control?

[agora]

You can't. That reply is nonsense; there is no ability to set a dimension on a date filter.  And it's a real issue. 

Instead, for now, it appears you have to specify the date field on each additional object you want filtered by the date control.  You can group numerous items and specify the same date field on a bunch, but then if you want to filter on two different dates you cannot, because each control can filter on one date field only, and the date filter just passes date values to that control which in turn has a fixed date field against which it compares.  Instead, there should be an optional dimension field on the date filter and if the other control doesn't have a date selected, it uses the field in the date control... But that's not allowed and so you cannot do this. 

Dates also don't respond to Advanced Filter, it seems.  If you pick a date as the dimension to filter, it doesn't react to things like Date > 01/01/2024; no effect on my trials.  

One thing that does work is using a dropdown or fixed size list. But that means you have to pick each individual date, which is ridiculous. 

[agora]

---

@Justine_L wrote:

Select the "End Date" control as the value.

---

This reply SOUNDS promising, but how on earth do you do this step?  When I create a filter, choose a date dimension, a comparison type like "After", it seems I can only enter static values -- not reference a control. Is there a video or article anywhere explaining how to connect the filter to the control?  

[Frisco]

I have the same issue and currently there is no solution.