Can chart increments be dynamic?

[dhreportme]

For example...

Store A does 100,000k a month and log into the dashboard and their chart increments by $10k up to say $150,000.

Store B does 10k a month and it should increment by $1k.

We have over 6,000 stores.

If the answer is Yes, any time of explanation would be helpful.

THANKS!

Post Edited by dhreportme at 08/08/2012 21:56

[cmatthews]

 

 

One idea on this is to use a multi axis chart and use different subdatasets/queries on the embedded charts. Create your queries in such a way that you create sales ranges for the resulting stores. first chart would have stores sales that range from 0 to 10000, second would be from 10001-20000, etc, etc, ranges based on whatever would produce a good quality chart increment. Each of the charts could have different tick. You could choose to show or not show the tick values to keep it less messy and create your own range legend manually.

The chart customizer class property is another approach, but I haven't use it yet.

Hope this helps,