Gauge Chart Problem?

[#1]

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...

[brenner_martina · Accepted solution]

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)

[#3]

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

[#4]

Thank you for responses.

All of them are working correctly...