Eclipse Community Forums: BIRT » Simple chart with no aggregation?

Home » Archived » 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 08:54

Eclipse User

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 15:37

Eclipse User

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!

Attachment: scatternoagg.zip
(Size: 4.08KB, Downloaded 257 times)

Re: Simple chart with no aggregation? [message #802624 is a reply to message #801025]

Mon, 20 February 2012 02:43

Eclipse User

Thanks a lot, Jason!

Re: Simple chart with no aggregation? [message #826871 is a reply to message #800790]

Thu, 22 March 2012 11:53

Eclipse User

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 12:17

Eclipse User

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!
>
>

Attachment: ScatterGroupingStacked.zip
(Size: 4.57KB, Downloaded 221 times)

Re: Simple chart with no aggregation? [message #827352 is a reply to message #826892]

Fri, 23 March 2012 04:00

Eclipse User

Thank you!

Previous Topic:	pdf formatting of an expandable report section?
Next Topic:	Data Sets and SQL Views

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 22:18:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter