How to Compare data Year Wise in gauge chat

[#1]

Hi community members,

How to compare the current and previous years sales in gauge chart

Regards,

Ramesh

[MayilVahanan]

Hi

Gauge charts are used to display the value of a single expression without dimensions.

So its not used for compare the sales report in same gauge chart..You can use pie or bar  chart for compare

[#3]

Hi ramasamy,

I want to display in two charts , one with current select and the other with previous years, is it possible

regard

ramesh

[MayilVahanan]

Hi

ya,it possible..

[#5]

please tell me how to write the script or in gauge chart

[MayilVahanan]

HI

No dimension:

1st gauge:

Exp:

=Sum({<Year = {'=$(=max(Year)-1)'}>}SalesTest) for max(year)-1

2nd gauge:

Exp:

=Sum({<Year = {'=$(=max(Year))'}>}SalesTest) for max(year)

[#7]

I am not getting the comparison ,just showing the gauge with needle showing a max point,will you please help me

regards,

rams

[MayilVahanan]

Hi

Its just show the values in gauge chart.. Use gauge chart for percentage calculation purpose.. Please use any other chart instead of it.