0 Replies Latest reply: Jan 28, 2013 6:50 AM by dbuijsman

# Problems with showing the right value in a gauge chart

Hello,

Im using an Gauge chart with three expressions and having some question about it.

It contains the following expressions:

Percentage (expr 2 / expr 3) :
Totaaldagenziek / Totaaldagengewerkt

Totaaldagenziek (The total number of sick dayes per year of all employees):
SUM(YEARSICKTIME)

Totaaldagengewerkt: (Total working days a year of all employees. The hours working in a week * the 52 weeks in a year / the 8 hours a working day stands for. And this minus the hours of in a yeark / the 8 hours a working day stands for)
SUM(URENWERKTIJD) *52 / 8 - SUM(VERLOFAFGEBOEKT) / 8

The result is showing as an percentage. But here is the problem, when i put my mouse at the point of the result it show all three values of the three expressions in the pop up. I want to let him only show the value of the first expression (the point is directing to the right value in the chart btw). I tried to make an textbox with '=Totaaldagenziek / Totaaldagengewerkt' to show the percentage value, but that won't work.

Someone any ideas?