Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
use total function in the denominator ->count(total(field))
use total function in the denominator ->count(total(field))
Thank you!!
Or use:
count({$<Status={'Complete'}>}Field) / count({$<Status=>}Field)