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

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 AdWords Top Contributor | Google Partner | GYBO | 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