Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Percentage view out of 2 totals
Percentage view out of 2 totals [message #1785193] Tue, 10 April 2018 14:19 Go to next message
Axel Bennemann is currently offline Axel BennemannFriend
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
Re: Percentage view out of 2 totals [message #1785366 is a reply to message #1785193] Fri, 13 April 2018 04:43 Go to previous messageGo to next message
Colin Sutton is currently offline Colin SuttonFriend
Messages: 102
Registered: July 2009
Senior Member
100*row["var1_cnt"]/row["var2_cnt"]
Re: Percentage view out of 2 totals [message #1785367 is a reply to message #1785193] Fri, 13 April 2018 04:44 Go to previous message
Colin Sutton is currently offline Colin SuttonFriend
Messages: 102
Registered: July 2009
Senior Member
100*row["var1_cnt"]/row["var2_cnt"]
Previous Topic:BIRT web service REST (JSON)
Next Topic:How to show dynamic value in master page footer when page break?
Goto Forum:
  


Current Time: Thu Sep 20 16:52:41 GMT 2018

Powered by FUDForum. Page generated in 0.01508 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top