AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.1K members online now
3.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Days between report level date range filter

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

I'm trying to calculate MinutesUtilized as a percentage of minutes available on a custom date range.  I already have a metric MinutesSpent which is a total of the minutes spent per period.  I already have a report level filter which the user can select the date range of interest.  I know that I have a fixed 500 minutes available per day, so what I want to do is:

 

MinutesUtilized = (MinutesSpent)/(500*NumberOfDaysInDateRange)

 

Where I'm stuck is: How do I get the NumberOfDaysInDateRange pulled out of a report level date filter?

 

Thanks!