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
4.9K members online now
4.9K 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

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

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?

Divide event worth with one row of the event total

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hello, 

 

Is there a way to divide two rows, in data studio?