Date Range Control- Change Field

[gcross24]

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 · Accepted solution]

@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.

[gcross24]

I do not see where you are saying to check/uncheck when editing the connection.

[RafaScardini]

Hi Mehdi_Oudjida,

Is it possible to the same using a different data source?
For instance, I'm using coupler.ai to connect my hubspot data to looker studio, however I cannot find a way to choose my field (hs_createdate) as my default date field. Note that in my looker studio there is NO "Date Range Dimension" option like the one on your screenshot, I  only have the "Default date range" selector.  

[gcross24]

I got it!  Thanks!