<p>Hello all,</p>
<p> </p>
<p>I am new to BIRT. I have been looking this up for a good amount of time now, and I think I may have found some solutions, some with beforeFactory, some with hiding, some with some extra tables, etc. Here's the situation: I have a nice cross tab based on data like this, with 3 categories, and a total of the people that match all 3:<br><br>
Favorite Sports Team | Favorite Ice Cream Flavor | Year Born | Number of People</p>
<p>Mighty Ducks | Strawberry | 1980 | 20</p>
<p>Mighty Ducks | Blueberry | 1980 | 45</p>
<p>Mighty Ducks | Strawberry | 1976 | 20</p>
<p>Barcelona | Strawberry | 1976 | 31</p>
<p>Barcelona | Chocolate | 1976 | 7</p>
<p>NY Jets | Chocolate | 1976 | 7</p>
<p> </p>
<p>Now, the sports teams' and ice cream flavors' allowable values are totally dynamic, i.e., I have no way of knowing what they might be beforehand. Same with the "Year Born"! The cross tab seems to handle this nicely.</p>
<p> </p>
<p><strong>Now, I want to allow the <em>user</em> to generate many types of charts with the y-axis being the "Number of People" column, or some aggregate of the values in the "Number of People" column, given specific combinations of the other column's values. What is the simplest and most maintainable way to allow a <em>user</em> to take this data and do the following?</strong></p>
<p> </p>
<p>Parameter 1: Favorite Sports Team</p>
<ul><li>User can select one, a few, or all sports teams</li>
<li>Next, the user can select to keep the "Number of People" values for the previous selection segregated, or aggregate the selection into a single value.</li>
</ul><p>Parameter 2: Favorite Ice Cream Flavor</p>
<ul><li>Likewise, for this, select, one, a few, or all</li>
<li>Likewise, next, with the previous selection, choose to keep the selected items segregated, or aggregate into a single value.</li>
</ul><p>Parameter 3: Year Born</p>
<ul><li>Likewise, for this, select, one, a few, or all</li>
<li>Likewise, next, with the previous selection, choose to keep the selected items segregated, or aggregate into a single value.</li>
</ul><p> </p>
<p> </p>
<p><strong>Example chart INPUT:</strong></p>
<p>1. At the "Sports Team" column, the user selects "Mighty Ducks" and "NY Jets", and selects to segregate this selection.</p>
<p>2. At the "Favorite Ice Cream" column, the user selects "All choices, aggregate"</p>
<p>3. At the "Year Born" column, the user selects "All choices, segregate".</p>
<p> </p>
<p><strong>Example Chart OUTPUT: Now, the user should get a chart of</strong></p>
<p>Y-Axis:"Number of People"</p>
<p>X-axis: there should be each year, separated into 2 different bars: "Mighty Ducks" and "NY Jets".</p>
<p> </p>
<p> </p>
<p> </p>
<p>This is just one potential chart the user should be able to generate; there will be VERY MANY possible charts (it will take combinatorics knowledge just to count them). Is it possible to do this without hand-making each possible chart?<br><br>
Let me know your ideas if you have them, or your candid opinion on what I should do next.</p>
<p> </p>
<p>Thank you very much in advance.</p>
<p> </p>
<p>-Joe</p>
