Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi,
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:
(Sum(If(gender='E',1,0))/Sum(If(gender='F',1,0))
(Count(All) - Sum(If(gender='E',1,0))) / Count(All)
or (Count(All) - Sum(If(gender='F',1,0))) / Count(All)
Hi,
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:
(Sum(If(gender='E',1,0))/Sum(If(gender='F',1,0))
(Count(All) - Sum(If(gender='E',1,0))) / Count(All)
or (Count(All) - Sum(If(gender='F',1,0))) / Count(All)
Use 3 expressions in your gauge chart:
1: Total count of customers
2: Count of customers where gender is F
3: 2/1
Promote expression 3 to be the first expression shown
That should work, i guess
Thank you for responses.
All of them are working correctly...