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

Looker Q&A Looker Studio
1

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?"

2

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!

1 Like
3

Thank you