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

Calculate with duration formated fields

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

In my Google Data Studio I've integrated a time entry list (see attachment).

 

Bildschirmfoto 2017-04-16 um 20.39.58.png

 

 

Inside the Data Studio I want to summarize all the task durations within the time range. 

 

Unfortunately, I can't choose the dimension "summary", when I change the format in DS to "duration". 

 

Do you have any solution or experience on this?

 

Thanks, 

 

Paul

 

 

Calculate with duration formated fields

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hello,

 

I am also facing similar issue and want solution for it.

 

Thanks,

Ami

Calculate with duration formated fields

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I too am having the same issue. I am thinking of creating a function in Google sheets to overcome this but I haven't a clue!