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
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

[FEATURE REQUEST] Constant containing number of days in date range

Top Contributor
# 1
Top Contributor

for the sake of average and such, it would be great to have either a constant or function to return the number of days in a date range.

 

Use case: calculating daily session average

Field AVG_DAILY_SESSIONS: COUNT(SESSIONS) / NUMDAYS

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan
1 Expert replyverified_user