Hi, I would like to create a calculated dimension to be able to create a pie graph later on, based on the following:
I have this table:
ID
GROUP
TYPE
1
A
X
2
A
X
3
A
Y
4
A
Y
5
B
X
6
B
Y
7
C
X
8
C
X
9
C
Y
I need to count ID's where TYPE = X and create a straight table like this:
GROUP
VALID
A
2
B
1
C
2
So I could create a calculated dimension:
if (valid>1, 'OK', 'Not OK')
and create a pie chart using the calculated dimension. Based on the example, the pie will have 2 slices where 'OK' represents 66.6% and 'Not OK', 33.3%
How do I create the straight table as I have mentioned in my original post without having to go to the script editor. Is there a way to do that using an expression?
