nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Chart to display individual series against overall average

AlanC

I have a dataset, coming from SQL Server, which results in a number of values, measured against 2 variables (Code and Date - see attached TestValues.csv). I need to chart individual Codes versus the overall average for each month in the range. 
e.g. 
 
Code Month1 Month2 Month3 ... 
A 2 3 4 
B 4 6 7 
C 6 9 11 
Average 4.0 6.0 7.3 
 
I want to chart A vs Average over a range of months. 
 
I've been trying all day to figure out a way of doing this, with no success <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif . Can anyone suggest a solution? I have also attached an Excel workbook showing the type of output I require. 
 
Thanks

Find more posts tagged with

Comments

mwilliams

Hi Alan,

What is your BIRT version? I'll try to come up with something from your data.

thuston

The data is not very helpful as it is only Jan 09 and Jan 10.

To get the Chart you need the same data setup as in Excel.
Somehow you have to add the Average values in so they can be another row series.

I suspect it would be easiest by Scritping in the Chart and adding the AverageSeries and calculating the Ave for each month on the fly.

AlanC

Hi Michael,
Thanks for replying. The version number is 2.3.2.

However, I have devised a solution by alternative means. Instead of querying the base table, I've created a "view" in SQL Server, which summarises the data for me. I can then, in BIRT, extract the data for each code and date, and then concatenate that with the overall averages. This seems to give me what I need.

Thanks again