11 Replies Latest reply: Mar 6, 2012 8:02 AM by chris goudy

# Text in Gauge Chart

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.

Any Ideas?

=Num((\$(esuccessful)/count(AgentCode))*100,0) &')' &'%'

• ###### Text in Gauge Chart

Hi,

Check with this

=Num((\$(esuccessful)/count(AgentCode))*100,0)&'%'

Celambarasan

• ###### Text in Gauge Chart

Hello,

Try this...

= '(' & Num((\$(esuccessful)/count(AgentCode))*100,0) &')' &'%'

IF NOT:

What is the value in variable and what is the Count(AgentCode). What is the output you want?

• ###### Text in Gauge Chart

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

• ###### Text in Gauge Chart

HI,

Try this

Num((\$(esuccessful)/count(AgentCode),'#,##0%')

Regards,

Kaushik Solanki

• ###### Text in Gauge Chart

nope,  still showing a null value

• ###### Text in Gauge Chart

HI,

Will you please share the QVW file.

Regards,

Kaushik Solanki

• ###### Text in Gauge Chart

Hi,

What expression you used for the gauge chart?

Celambarasan

• ###### Text in Gauge Chart

this is the expression i used

=\$(eSuccessful)/Count(AgentCode)

• ###### Text in Gauge Chart

Hi,

Try with this.

=Num(\$(=eSuccessful)/Count(AgentCode),'###%')

if not working

Can you tell me what expression you have used in the variable eSuccessful?

Celambarasan

• ###### Text in Gauge Chart

works, thanks a lot!

• ###### Re: Text in Gauge Chart

Hi,

Why dont u try

=num(\$(eSuccessful)/Count(AgentCode),'#,##0%')

Regards,

Kaushik Solanki