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
Solved! Go to Solution.
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.
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.
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 .