'Count if' of simple text values

[#1]

Dear All,

I can't manage to simply count particular text values in a field with the 'count if' expression. Who could help me with this?

Much thanks. Arthur

[swuehl]

Not sure if I completely understand, but maybe like

=sum( if(match(YOURFIELD,'TextA','TextB','TextC'),1,0) )

You could also use Wildmatch to use wildcards in your search.

[#3]

Artur - is it possible that you can maybe ellaborate please - maybe with an example.

[#4]

See the images.

I want a bar chart showing me the percentage of MALE employees / Total number of employees.

So how can I count 'true' and divide this by total number of employees.

It must be 60% but I can't figure out how to enclose this into an graph expression.

Much thanks to help me as beginner.

[SunilChauhan · Accepted solution]

take a bar chart and in expression

use below code

Count(if(Male='true',Employee))/count(Male)

or you can

see the attached file

[#6]

Why didn't you just count the number of employee and check the option "Relative" ?

[SunilChauhan]

relative is not serving the purpose  i belive

[#8]

Thanks Sunil, you fixed my problem. The 'relative' option doesn't fit for now, but good to knwo this option.

Much Thanks! Arthur

[SunilChauhan]

first of all mark this as correct .which will indicate issue is closed .

relative  is best suited where distribution is required . like out of 100% , 20% is a,30% is b, 50% is a .

[#10]

Very helpful. I had a very similar problem and this method worked perfectly with wildmatch.