Chart Expression

[#1]

Can anyone help me figure out how to get my speedometer guage to show the right thing? My expression is as follows:

=count({$<Status={'Complete'}>}Field)/Count(Field) 

That expression equals 0.57, and my guages are set at Min=0 and Max=1. But the guage says it equals 1. What am I doing wrong?

[Anonymous · Accepted solution]

use total function in the denominator ->count(total(field))

[#3]

Thank you!!

[#4]

Or use:

count({$<Status={'Complete'}>}Field) / count({$<Status=>}Field)