Divide event worth with one row of the event total[ Edited ]
June 2017 - last edited June 2017
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?