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

Divide event worth with one row of the event total

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello community,

 

I have a problem with data studio and hope someone can help me.

 

I would like to display the right average viewing time. I track it with an GA event. To display the average viewing time I have to divide the event worth (25.220) through the event total. The problem is that I can't use the event total number but I must use the event total number of the event label "10" (159) (see picture).

 

I tried all options, forms and filters but I didn't find a solution. Have someone a solution or an idea?

 

Many Thanks.

average viewing time.JPG

Divide event worth with one row of the event total

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

So if you create a table in Data Studio where your dimension is set to Event Label and your metric is set to a calculated field of (Total Events / 25.220) that doesn't give the results you want?

Divide event worth with one row of the event total

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for your answer.

 

If I do this, the problem is that the metric "Total Events" is 2522 and not 159. I need the total event of the event label 10 like 159.

 

Do you know what I mean?