Reference start and end date of a date range control in a calculated field

Looker Q&A Looker Studio
,
1

Hello All,

I am trying to reference the start and end dates of a date range control in a calculated field, but I am having a lot of trouble with this. Does anyone have any ideas?

Thanks

2

If the query is a BigQuery custom query, you migth use the parameters (enable range parameters) and add two fields to your custom query: @ds _START_DATE as start_date, @ds _END_DATE as end_date

1 Like
3

@Francesco_V why this parameters only work for BigQuery custom query, and not on Mysql or PostgreSQL?

4

hi i have a similar problem, i’m using google sheet.
i would like to create a calculated field, example:
all values ​​= “minivan” of the car field, but sold in a date range.
this can be done easily by applying the date range size filter.
but i need to do it in the calculated field expression, i can’t use start date and end date.
i hope i explained myself well, thank you very much