Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am doing Gender Distribution,
Suppose If i have more than F percentage i want to show one Image..
If i have more than M percentage i want to show Different Image..
How to write hide and show conditions for 2 Images based on Gender Percentage..????
Thanks in Advance..
Hi,
You can use conditional hide in this case.
Male Expression
=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100>Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100
Female Expression
=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100<Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100
Edit: If the male and female percentage is equal, the above expression will not show any images. To avoid that replace less than and greater than symbols as <= and >= in above expressions. You can see both the images () whenever the percentage is equal.
Hi,
You can use conditional hide in this case.
Male Expression
=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100>Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100
Female Expression
=Count({<genger={'M'}>}ID)/Count(TOTAL ID)*100<Count({<genger={'F'}>}ID)/Count(TOTAL ID)*100
Edit: If the male and female percentage is equal, the above expression will not show any images. To avoid that replace less than and greater than symbols as <= and >= in above expressions. You can see both the images () whenever the percentage is equal.
HI
PFA