I got a report in Google Looker studio. In one field I need to divide the value by the number of days, according to the selected period. I understand that I can use the date_diff function, but how can I provide this function with the current values from the date range filter (which can be changed by the user)? Thanks!
Chat GPT advised me to use this to extract the dates, but it just does not work.
PARSE_DATE(“%Y-%m-%d”, “end_date_filter_value”)
New contributor
Roman Peterský is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.