Guage Chart

[Karahs]

Hello Community,

How can i show the following exampe in a guage chart?

Eg.

if we want to show the results of this year revenue against last year revenue

for eg.

lat years revenue was 100 inr

and this years revenue so far is 80 inr

then its 80% so far

but lets say by dec this years revenue becomes 125 inr

then we have achieved 125% so far this year.

Thanks in advance!

[arvind_patil]

Hi Kshitija,

You can write set expression for revenue

Sum(<Year={'$(=Max(year)'}>}Revenue)/Sum(<Year={'$(=Max(year)-1'}>}Revenue)

In presentation tab Check Show %

Thanks,

Arvind Patil

[Karahs]

Hi Arvind,

Thanks for the reply , but the expression is not working!

Thanks,

Kshitija Shinde

[Anonymous]

=num(sum({<year={$(=max(year))}>}rev)/

sum({<year={$(=max(year)-1)}>}rev),'####%')