Thanks for your reply. However I was able to achieve the solution which you have provieded. My question is only in y-axis, in front of all the number $ symbol should be coming. like $1000000, $ 2000000, $ 3000000 etc. is that possible. I have tried in changing the money format and other this like adding $ in format as well, but didn't work
If you have any solution, please let me know.
thanks & regards
Good find Eric.
I've created a code snippet that you can put into the expression window for Static Step so that you still get a good-looking chart:
=round(max(aggr(<expression>,<dimension>))/<number of chart divisions>,5*pow(10,floor(log10(max(aggr(<expression>,<dimension>))))-1))
It's a good idea here to set your expression to a variable so that when you need to change the expression it's changed everywhere. For example, if you had a chart showing sum of sales by year, you'd do something like this:
Set veSumSales = num(sum(Sales),'$#,###,###') //Do this in script or just set it in the Variable Overview
For the chart expression, just use =$(veSumSales)
For the chart dimension, set it to Year
For the Static Step, assuming we want a 0 and three additional labels on the axis, in this example you would use:
In the event you have multiple expressions, you'd need to wrap each one up in a Max(Aggr(<expression>,<Dimension(s)>)) and then wrap that whole thing in a RangeMax function.