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

Get TOTAL EVENTS when EVENT CATEGORY = X

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I've been asking about a problem in another thread, but what it boils down to is this.

 

I need to isolate numbers so that I can do calculations. The numbers are effectively:

 

TOTAL EVENTS when EVENT CATEGORY = "something"

 

Can this be done?

 

Thanks

1 Expert replyverified_user

Get TOTAL EVENTS when EVENT CATEGORY = X

Rising Star
# 2
Rising Star

Why can the standard reports not deliver this for you? Category can be viewed in the reports found under behaviour>events>top events, along with total and unique events. Can you give some more detail?

If you wish to have more than one parameter in your event category (e.g. event category matches trousers|pants) then you could use a custom report with a filter on event category. 

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Get TOTAL EVENTS when EVENT CATEGORY = X

[ Edited ]
Rising Star
# 3
Rising Star

Apologies - thought this was under the google analytics forum, missed that it was under data studio. My bad.

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Get TOTAL EVENTS when EVENT CATEGORY = X

Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

thanks, so can it not be done?

Get TOTAL EVENTS when EVENT CATEGORY = X

Rising Star
# 5
Rising Star

Sorry, I'm no expert when it comes to data studio so I don't know.

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Get TOTAL EVENTS when EVENT CATEGORY = X

Explorer ✭ ✭ ☆
# 6
Explorer ✭ ✭ ☆

@Michael C

 

Can you add a screenshot about what you want to do exactly ? 

Get TOTAL EVENTS when EVENT CATEGORY = X

[ Edited ]
Follower ✭ ☆ ☆
# 7
Follower ✭ ☆ ☆

Hi Michael,

I think you can do this using a counter and filters. Create a new metric:

CountEvent = event*1 (just so it's a copy and won't affect your data). 

Set the aggregation to count. 

Then add a filter on the graph at the bottom of the Data tab: 

Include "Event" contains "Something".

 

// Edit - you don't need to count it if your data is already integers and is set to sum. 

Be clever with how you name filters Smiley Happy