Eclipse Community Forums: BIRT » Percentage view out of 2 totals

Help

Home

Home » Archived » BIRT » Percentage view out of 2 totals

Show: Today's Messages :: Show Polls :: Message Navigator

Percentage view out of 2 totals [message #1785193]

Tue, 10 April 2018 14:19

Axel Bennemann

Messages: 1
Registered: April 2018

Junior Member

I have a grouped bar chart, showing the totals for two different artifact types over time (monthly view). The data source is a join dataset.
Example:

Jan Bar1: 26 Bar2: 43
Feb Bar1: 31 Bar2: 36
Mar Bar1: 26 Bar2: 49

So far so good. But instead of the 2 Bar chart showing the totals, I would like to see a 1-Bar chart, just showing the percentage ratio of the totals per month!
In our example:
Jan 26/43 => 60,46%
Feb 31/36 => 86,11%
Mar 26/49 => 53,06%

Question: how to get there? I already tried with different aggregations but did yet not yet succeed (e.g. row["var1_cnt"]/row["var2_cnt"]).
Thanks for any help!

BR
Axel

Report message to a moderator