Percentage view out of 2 totals [message #1785193] |
Tue, 10 April 2018 10:19  |
Eclipse User |
|
|
|
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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.09094 seconds