Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community members,
How to compare the current and previous years sales in gauge chart
Regards,
Ramesh
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
Hi ramasamy,
I want to display in two charts , one with current select and the other with previous years, is it possible
regard
ramesh
Hi
ya,it possible..
please tell me how to write the script or in gauge chart
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)
I am not getting the comparison ,just showing the gauge with needle showing a max point,will you please help me
regards,
rams
Hi
Its just show the values in gauge chart.. Use gauge chart for percentage calculation purpose.. Please use any other chart instead of it.