Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsSimple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/800790/#msg_800790
I am trying to create a simple scatter chart to display a distribution of values.
The problem I have is that Birt forces me to choose an Aggregate Expression...
Here is an example of a data set and the kind of chart I'd like to create with Birt:
dl.dropbox.com/u/39967131/Chart.PNG (sorry, I can't post links because I'm new on the forum )
With this chart I can see quickly what are the various prices associated with each item.
In my example, since Birt wants to use an aggregate expression (by default the Sum), I can't have two different values on the chart for the item 1, and instead I will get item 1 => price 5 (the sum of the two values 2 and 3).
Is there a way around this problem?
Thanks!]]>David B.2012-02-17T13:54:27-00:00Re: Simple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/801025/#msg_801025
and sorting editor button on the Category (X) Series line. It is right
next to the Fx button. Un-check the grouping check box. See attached
example.
Jason
On 2/17/2012 8:54 AM, D B wrote:
> Hi,
>
> I am trying to create a simple scatter chart to display a distribution
> of values.
> The problem I have is that Birt forces me to choose an Aggregate
> Expression...
>
> Here is an example of a data set and the kind of chart I'd like to
> create with Birt:
> dl.dropbox.com/u/39967131/Chart.PNG (sorry, I can't post links because
> I'm new on the forum :( )
>
> With this chart I can see quickly what are the various prices associated
> with each item.
> In my example, since Birt wants to use an aggregate expression (by
> default the Sum), I can't have two different values on the chart for the
> item 1, and instead I will get item 1 => price 5 (the sum of the two
> values 2 and 3).
>
> Is there a way around this problem?
>
> Thanks!]]>Jason Weathersby2012-02-17T20:37:11-00:00Re: Simple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/802624/#msg_802624
David B.2012-02-20T07:43:33-00:00Re: Simple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/826871/#msg_826871
Now I am trying to do the same thing (a scatter chart), but this time the X axis data type is String.
I unchecked the grouping check-box but this isn't working anymore!
Here is a screenshot of an example with the issue am having: dl.dropbox.com/u/39967131/Problem.PNG
In the chart, there should be only one occurence of "John" and "James" and not 3 for each name...
Thanks in advance!
]]>David B.2012-03-22T15:53:00-00:00Re: Simple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/826892/#msg_826892
If so enable grouping on the category. This will create a summed value
for james and john, Next add an optional grouping using the row number:
row.__rownum as the expression. This will create a unique series for
each row number causing multiple markers in the james and john field
doing away with the sum. See attached example.
Jason
On 3/22/2012 11:53 AM, David B. wrote:
> Hi again,
> Now I am trying to do the same thing (a scatter chart), but this time
> the X axis data type is String.
>
> I unchecked the grouping check-box but this isn't working anymore!
>
> Here is a screenshot of an example with the issue am having:
> dl.dropbox.com/u/39967131/Problem.PNG
> In the chart, there should be only one occurence of "John" and "James"
> and not 3 for each name...
>
> Thanks in advance!
>
>]]>Jason Weathersby2012-03-22T16:17:26-00:00Re: Simple chart with no aggregation?
https://www.eclipse.org/forums/index.php/mv/msg/293274/827352/#msg_827352
David B.2012-03-23T08:00:01-00:00