Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 5 different event ids out of 8 that I want to aggregate against. But I then want to display the values in the dimension column from two separate columns.
Here's my data and it will make sense.
eventID Category Group
1 fruit something
2 vegetable something
3 other apples
4 other oranges
5 vegetable something
6 other apples
7 other oranges
8 other bananas
This would display the Category name in the column for my dimension and expressions would only aggregate for 1-5.
if(match(eventID, '1','2','3', '4', '5'), Category)
What I would like to do is pull only eventIDs 1-5 but in the dimension column display the Category if 1,2,5 and the Group if 3,4.
Hope this makes sense.
Thank you.
Why is it that the second I post a question the answer comes to me. It's a two step solution.
First I created the first calculated dimension
=if(match(EventID, '4','1','2','19', '21'), EventID)
then set this to not display if null and then hide the column.
then my dimension names column as
=if(EventID = '4', Category, Group)
Why is it that the second I post a question the answer comes to me. It's a two step solution.
First I created the first calculated dimension
=if(match(EventID, '4','1','2','19', '21'), EventID)
then set this to not display if null and then hide the column.
then my dimension names column as
=if(EventID = '4', Category, Group)