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

Struggling with filters

[ Edited ]
Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hello! 
I'd like to ask a question, so that hopefully you can help solve my issue. I have in Data Studio data from Google Analytics, which is: 

 

Total Sessions

Sessions (filtered with regex)

 

I'd like to add a metric that can compute the % of filtered sessions / total sessions. 

I tried with CASE WHEN REGEXP_MATCH, 

 

but it seems not to be the solution to my problem. Do you know if doing something like that is possible in Data Studio? And if yes, can you please tell me how? 

 

Thanks a lot!
Eugenio

Struggling with filters

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

nobody can help?

thanks

eugenio

Struggling with filters

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

I am not sure I understand your problem - does a simple formula like Sessions/Total Sessions work? Then format as a %. This is the % unfiltered. So if you need % filtered it would be 1 - (Sessions/Total Sessions).