Skip to main content

In a Looker Studio Dashbaord I want to just count the number of days in a selected Date Range. 

 

I’ve seen threads to use DATE_DIFF(MAX(Day),MIN(Day))

 

Not working. any suggestions appreciated

Hi @msacco, the method of creating a calculated field and visualizing it as a scorecard is a solid one. The formula you provided should usually work by replacing “Day” with “Date”. Of course the correct field depends on the exact connector you are using.

Another approach is to use COUNT_DISTINCT(Date), but note that this will exclude dates where no metrics are available.

Let me know whether that was helpful!

Reply


Terms & ConditionsCookie settings