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

Finding Date Difference and Count How Many

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

 

I have 2 dates (received and completed), I'm trying to find the number of instances their differences occurred (how many were completed within 1 day, how many within 5 days, etc)

 

 

2 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Alexander P
January 2017

Finding Date Difference and Count How Many

Google Employee
# 3
Google Employee

Hi Alexander,

 

You can use the DATE_DIFF function, like this:

 

DATE_DIFF(Completed, Received)

 

You can then use that new field to aggregate the data in your charts, create filters, etc.

 

Here's more info on calculated fields: https://support.google.com/360suite/datastudio/answer/6299685

 

Hope that helps!

 

Rick

View solution in original post

Finding Date Difference and Count How Many

Top Contributor
# 2
Top Contributor

Hi @Alexander P,

 

What is your data source? Data Studio is only as powerful as the data source used. You can review this information for more help. 

 

Kind Regards,

 

James

____________________________________________________________
Google My Business & Google Ads Top Contributor
Google Partner | GYBO Agency | Local Guide | My Profile


 


 


 

Marked as Best Answer.
Solution
Accepted by topic author Alexander P
January 2017

Finding Date Difference and Count How Many

Google Employee
# 3
Google Employee

Hi Alexander,

 

You can use the DATE_DIFF function, like this:

 

DATE_DIFF(Completed, Received)

 

You can then use that new field to aggregate the data in your charts, create filters, etc.

 

Here's more info on calculated fields: https://support.google.com/360suite/datastudio/answer/6299685

 

Hope that helps!

 

Rick