Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Simple chart with no aggregation?(Is it possible not to use an aggregate expression?)
Simple chart with no aggregation? [message #800790] Fri, 17 February 2012 13:54 Go to next message
David B. is currently offline David B.Friend
Messages: 24
Registered: February 2012
Junior Member
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 Sad )

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!
Re: Simple chart with no aggregation? [message #801025 is a reply to message #800790] Fri, 17 February 2012 20:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Select the second tab (data) in the chart wizard. Click on the grouping
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!
Re: Simple chart with no aggregation? [message #802624 is a reply to message #801025] Mon, 20 February 2012 07:43 Go to previous messageGo to next message
David B. is currently offline David B.Friend
Messages: 24
Registered: February 2012
Junior Member
Thanks a lot, Jason!
Re: Simple chart with no aggregation? [message #826871 is a reply to message #800790] Thu, 22 March 2012 15:53 Go to previous messageGo to next message
David B. is currently offline David B.Friend
Messages: 24
Registered: February 2012
Junior Member
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!

Re: Simple chart with no aggregation? [message #826892 is a reply to message #826871] Thu, 22 March 2012 16:17 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I assume you still want a marker for each data point, so 3 from James?
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!
>
>
Re: Simple chart with no aggregation? [message #827352 is a reply to message #826892] Fri, 23 March 2012 08:00 Go to previous message
David B. is currently offline David B.Friend
Messages: 24
Registered: February 2012
Junior Member
Thank you!
Previous Topic:pdf formatting of an expandable report section?
Next Topic:Data Sets and SQL Views
Goto Forum:
  


Current Time: Fri Nov 28 11:17:50 GMT 2014

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

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