Looker Studio: Setting Up a 6 AM - 6 AM Operational Day Filter

[Mholi]

Hi there

I need guidance for setting up a report filter in Looker Studio.

My Goal: I want users to select a start date and an end date using Looker Studio's standard date range control. Based on this selection, the report should display data for a precise period: from 6:00 AM on the selected start date up to  6:00 AM on the selected end date.

Example:

• If a user selects:
  • Start Date: May 9, 2025
  • End Date: May 10, 2025
• The report should show all data from May 9, 2025, 6:00:00 AM through May 10, 2025, 5:59:59 AM.

My data source has a standard timestamp field (let's call it OriginalDateTime) that includes both date and time.

What is the most effective method in Looker Studio to achieve this? Should I use a calculated field? If so, what would the formula be? And how should the date range control and the report's charts/tables be configured to use this setup dynamically?"

[sam8 · Accepted solution]

I can't think of any way to do this in Looker Studio. 

The only solution I can think of would be in Looker, not Looker Studio, using the date_start and date_end variables. Something like:
  IF date = date_start_variable THEN "time >= 6AM"
    ELSE IF  date  = date_end_variable THEN "time < 6AM"
    ELSE "any time"

For Looker Studio, this would be a feature request! 

[Mholi]

Thank you