I'm trying to add text to my Gauge chart so that you can see the percentage.
I have the following expression, but something isn't right.
=Num(($(esuccessful)/count(AgentCode))*100,0) &')' &'%'
Solved! Go to Solution.
= '(' & Num(($(esuccessful)/count(AgentCode))*100,0) &')' &'%'
What is the value in variable and what is the Count(AgentCode). What is the output you want?
neither of those are working either.
They all show up as Null values
Count(AgentCode) - counts the number of calls made
esuccessful - counts the number of successful calls
If you hover the mouse over the gauge chart, it shows the percentage of successful calls over total calls.
But i want to be able to see that percentage without hovering the mouse over the chart