Data Studio
5.5K members online now
5.5K 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!