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

How to add Time as a duration in DS (Data source - Sheets)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

How do you add Time in duration format to a report. I have tried multiple techniques but non of them work, I am using google sheets as a data source. The time column in google sheets is in "duration" format, but once I bring it into DS and change the format in DS to duration (Aggregation: SUM) it does not give me any results in my graph.

 

STEP 1:

 

DS-totoal time.JPG 

 

STEP 2:

 

total tim-top10.JPG

How to add Time as a duration in DS (Data source - Sheets)

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Hi,

 

I had the same problem, I resolved it by setting the number format to "automatic".

For example, an average session duration is : "209.5615572" and not "00:03:30".

 

I hope this will help you.

How to add Time as a duration in DS (Data source - Sheets)

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I'm having exactly the same issue and changing the number format to "automatic" does not fix it.Data Studio not graphing DURATION

How to add Time as a duration in DS (Data source - Sheets)

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi,

 

I too am facing similar issue with my duration field.

 

Please let me know if you get any solution.

 

Thanks,

Ami