|Dynamic dial chart scale [message #948956]
||Thu, 18 October 2012 14:48
| Tobbi Filteau
Registered: September 2011
I'm currently doing a sparkline chart in BIRT that resembles the one presented here (just so you have a general idea of what sort of context I'm working with):|
This part went swimmingly, but now, I'd like a dial chart at the end of the line that shows where the average payment is located in relation with the maximum payment and the minimum payment.
So essentially, I want the minimum payment as the minimum value on the dial's scale and the maximum payment as the maximum value on the dial's scale. So, I created three aggregations in my table to extract this data (one for the average, one for the max and one for the min).
However, while I can set these aggregations as dials for the chart, I can't set any of them as the max and min for the scale. In my case, hardcoded values are impossible to set since, from one product to another, my values change greatly (for example, one can be between 100 and 200 while the next goes from 5000 to 10000... try hardcoding that!!!). And there's also WAY too many product to do each one of them by hand.
Obviously, the chart has access to the aggregations since I can choose them for dials... so why only dials and not the min and max of the scale too? I saw this post:
which sets the min and max via a script... but again the values are hardcoded, which sucks because it's otherwise exactly what I need to do.
Any suggestion would be greatly appreciated.
Powered by FUDForum
. Page generated in 0.08648 seconds