|
Re: Simple chart with no aggregation? [message #801025 is a reply to message #800790] |
Fri, 17 February 2012 20:37 |
|
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 #826892 is a reply to message #826871] |
Thu, 22 March 2012 16:17 |
|
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!
>
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.03362 seconds