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

Count countries where revenue > 0

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to count the number of countries where the revenue is larger than 0.

 

I haven't found anything that works so far.

 

This:

COUNT(CASE WHEN Revenue >0  AND Country !="" THEN  1 ELSE 0 ENd)

 

gives me the error "Re-aggregating metrics are not supported"

 

Is there a work around to get this number?

 

Best,

bert

Count countries where revenue > 0

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Hi Bert,

 

I asked a similar question with no luck so far.

 

As the error message says and also the documentation mentions, it's currently just not possible.

 

With some patience and luck we should be able to do these kind of things in the future. Data Studio is still in Beta after all.

 

Best Regards!