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
3.2K members online now
3.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Find percentage between two scorecards

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hello,

 

I have one scorecard that is Total Events with one filter and a second scorecard that is Total Events with two filters.  How do I create a third scorecard with the percentage of those two numbers?  My theory is to create a calculated field for each scorecard and then a third for the percentage but I wouldn't even begin to know how to do that.  This is the break down:

 

1.  Total Events.  Filter: Include Event Action equals full-episode-start

2.  Total Events.  Filter1: Include Event Category contains video.  Filter2: Include Event Action regex clip-75

 

Thank you for any help!