Gauge
SQL
SELECT sum(case when COMM is null then 0
when COMM = 0 then 0
else 1 end) value
, count(*) max_value
FROM apa$nf_emp
Information
This page contains a Dial chart, with a Gauge Frame type of Auto Rectangular used to control the general appearance of the chart. To control the positioning of the Minor Ticks, a Minor Interval level of 1 has been set. The angle of the chart is controlled by the Start Angle and Sweep Angles, which have been set to -90 and 180 respectively. A marker has been used as the Gauge pointer, identifying the gauge value of 3.