<p>I'm using the newest version of BIRT open source and I've built a bar chart which uses the Values (Y) Series, Category(X) Series and the Optional Y Series Grouping like in the picture. </p>
<p>My dataset contains sessions, minutes, etc. For the Value (Y) Series I can only found a distinct count function with that I can count the number of the different sessions depend on the X Series and the Y Grouping. </p>
<p>My problem is that I want to sum up the minutes of distinct/different sessions on the X Series and the Y Grouping.</p>
<p> </p>
<p>Dataset:</p>
<p>ID Session MinutesOfSession XSeries YGrouping (not important for the example)</p>
<p>143 1 4 aaa</p>
<p>23 1 4 aaa</p>
<p>5 2 3 bbb</p>
<p>66 3 1 aaa</p>
<p>44 4 8 ccc</p>
<p>22 4 8 ccc</p>
<p> </p>
<p>Diagram I want to have: false: I get with distinct count on Session: false: I get with sum on Minutes:</p>
<p> </p>
<p>aaa 5 minutes 2 9</p>
<p> </p>
<p>bbb 3 minutes 1 3</p>
<p> </p>
<p>ccc 8 minutes 1 16</p>
<p> </p>
<p>Is there a possible solution? Maybe using Sum function and the expression builder?</p>
<p>Thanks a lot!</p>
<p> </p>
<p><img src="
https://enterprisesmartapps.files.wordpress.com/2012/01/cgvchartselectdata.jpg" alt="cgvchartselectdata.jpg"></p>
