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

Count of Days in month?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

When creating a customer field, can I get a count of the days in the month?

 

Context: want to multiple my daily budget from an AdWords source by the days in the month. 

 

Thanks, 

1 Expert replyverified_user

Count of Days in month?

Top Contributor
# 2
Top Contributor

Hi Alex, 

this is unfortunately not available. 

Your best bet is is to create "monthly averages" by creating custom fields where you divide a metric by 30 to get a monthly average.

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

Count of Days in month?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for reply. 

 

I'll see if I can do it manually with a CASE statement and detect the current date and return an integer of month days.