Data Studio
2K members online now
2K 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