topic Re: Expressions with Conditions in App Development

Expressions with Conditions

EvanBarrick — Fri, 15 Mar 2019 18:34:05 GMT

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

Re: Expressions with Conditions

Wlad_Masi — Fri, 15 Mar 2019 21:24:03 GMT

What about If(Gender ='Male' or Gender ='MALE' or Gender = 'rbtMale', count UserID) ?

You may be able to use substring function, but I think you will have to use a function to change everything to lower case and look for the substring "Male" after it.

Re: Expressions with Conditions

Vegar — Fri, 15 Mar 2019 22:20:07 GMT

You could solve it by using set analysis

Male:

= count({<Gender={'Male','MALE','rbtMale'}>}UserID)

Female:

= count({<Gender={'Female','FEMALE','rbtFemale'}>}UserID)

Vegar