First some background. I maintain a database with benchmark results,
From this database I make selections and present the resulting query in ARTIOFusionCharts. This works great, since they are dynamically linked to the MySQL database. Even when I add new results or change existing results, the charts are updated automatically.
To see how this works, see:
ppbm7.com/index.php/results?showall=&start=1
However, to make the charts more readable, I want to add trendlines to these charts, indicating D9 (upper decile), Q3 (upper quartile) or Med (median) levels. For now I have entered these trendlines manually, but you can already see the problem. What if I add a number of new submissions to the database and the values for upper decile, upper quartile and median change? I now have to modify each and every chart manually and change the numeric values by hand.
Is there any possibility to add trendlines based on a MySQL query, so the current numeric values become dynamic in nature in terms of start value and end value? Or is that a feature request?
