Using two aggregate functions in a chart

Hi All,

I need to use two aggregate functions(sum,avg) in one chart.

I have to calculate count of a column and that has to be grouped as sum for a week. which will be on y1 axis

and i have some other cols called SR,SSR,Total.Now i need percantage of SR and percentage of SSR out of total...

So i'll calculate percentage for each day and i'll find the Average percentage for a week.. which will be on y2 axis

SO i want Both average and sum as aggregate functions in the chart..

Can i have 2 aggregate functions in a single chart..

Or if you have any other suggestions please tell..

Thanks in advance..

Regards,

Sankar Ganesh

Find more posts tagged with

Comments

mwilliams

Hi Sankar,

If you have multiple axes, I don't see why you could use multiple aggregations on the y-axis values.

BIRTing

Hi Michael,

Why i need two aggregate function is , in one y axis i'll have count of values which will be grouped by week.I am calculating this count for each day and i group by week .So I use sum() function.

For another y axis , i calculate a percentage value for each day and I group by week.So I have to use avg() ..

How to acheive this. need your help

Thanks,

Sankar Ganesh

mwilliams

Sankar,

Can you set up a report with the sample db like you're talking about, so I can see exactly where you're at? What version of BIRT are you using?

BIRTing

Hi Michael,

I have attached my report here..

Please have a look in 'chartdataSet'....

Tell me if u need any clarifications

Thanks

Sankar Ganesh

mwilliams

Sankar,

So, you're using version 2.1.1? Is this a requirement? Newer versions of BIRT have better aggregation in chart features.

BIRTing

Michael,

So Is it possible to have two aggregate function in newer versions of BIRT??

Do you have any idea??

Thanks,

Sankar Ganesh

mwilliams

Sankar,

You can add different aggregations for your different series' in the chart editor in newer versions of BIRT.