Hi;in my database 1. column is Gender(value is "E" or "F") 2. column is customer_name(e.g. "John")
I would like to count and show male and female customers in Gauge Chart. I try it but I failed...Any idea about this problem ?
Thanks in Advance...
what do you want to show in the gauge chart? Percentage of "E" or "F"? Percentge "E" of all? Percentage "F" of All?
Put the expression:
(Count(All) - Sum(If(gender='E',1,0))) / Count(All)
or (Count(All) - Sum(If(gender='F',1,0))) / Count(All)
Thank you for responses.All of them are working correctly...
Use 3 expressions in your gauge chart:
1: Total count of customers
2: Count of customers where gender is F
Promote expression 3 to be the first expression shown
That should work, i guess
Retrieving data ...