Solved: Date Range Control- Change Field - Page 2

gcross24 · 09-23-2024 10:01 PM

I built a report using a field for date range control that has both date and time. When looking at sales data, if I choose an option like "Yesterday", it appears to only pull back records with a datetime that matches XX/XX/XXXX 00:00 exactly to the minute. I want to update the date range control dimension to a calculated field that changes all values to a date. I created this field and now want to apply this to the date range control. I do.not have an option to change the dimension that the date range control uses. Any ideas?

Mehdi_Oudjida

@gcross24

Which data source type you are using?
As example, BigQuery tables can be configured as data source selecting the partitioned date field as the date field for date range control. You just need to go the the connection configuration of the data source and uncheck the date field, then select another calculated field in the report, page or chart level. See "Date range Dimension" in the example below.

I hope it helps.

View solution in original post