Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a simple pie chart for gender. The data set has these possible values for Gender
-FEMALE, Female, MALE, Male, rbtFemale and rbtMale
I want to create the chart where I group the Female, FEMALE and rbtFemale into a expression as Female and the same for Male.
So I think my expression would be something similar to =Count(If(Gender ='Male' or Gender ='MALE' or Gender = 'rbtMale', UserID)) but I do not get the expected results
You could solve it by using set analysis
Male:
= count({<Gender={'Male','MALE','rbtMale'}>}UserID)
Female:
= count({<Gender={'Female','FEMALE','rbtFemale'}>}UserID)
BR
Vegar