|
Re: Area Chart - Only show top 5 and summation of remainder [message #888969 is a reply to message #888828] |
Mon, 18 June 2012 20:51 |
|
Have you tried to use a top N filter on the chart?
Jason
On 6/18/2012 1:18 PM, Ronan Murphy wrote:
> Hi all,
>
> I'm trying to create a percentage area chart or stacked bar chart that
> will show the grouped results of only the top 5 groups (ideally by the
> sum of the entire date range) and a summation of all other groups.
> Showing all the groups makes the chart illegible.
> The input data is a variable number of groups and different group
> titles, depending on user selection. I currently have a chart that is
> using the Optional Y Series Grouping and sorting by quantum, but can't
> find a way to only show top 5 groups.
> I'm using BIRT 3.7.2
>
> All thoughts and ideas welcome!
> Thanks for the help
|
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889253 is a reply to message #888994] |
Tue, 19 June 2012 04:12 |
|
This is most likely because the filter is happening before the
aggregation. Take a look at the topn example attached that aggregates
in the data set and then filters on the chart.
Jason
On 6/18/2012 5:24 PM, Ronan Murphy wrote:
> I have tried that and had some issues. My chart is set up as:
> X-axis: dates
> Y-axis: sales volume (integer)
> Y-Grouping: product (string) (Sorted descending on sales volume)
>
> I have the filter set up on Product - Top n - report parameter (integer)
>
> However this always gives me a single Product category rather than top
> 5. I also tried it unsorted and get same result.
>
> Will the top n filter also give me (or is it possible to include) a
> summation of all the categories that are not in the top 5? As we are
> looking at percentage area charts we would misrepresent the data
> otherwise, and it is an important element of the report.
>
> Apologies if it is a rudimentary question, I'm new to the program!
> Thanks again
>
>
>
> Jason Weathersby wrote on Mon, 18 June 2012 16:51
>> Have you tried to use a top N filter on the chart?
>>
>> Jason
>>
>> On 6/18/2012 1:18 PM, Ronan Murphy wrote:
>> > Hi all,
>> >
>> > I'm trying to create a percentage area chart or stacked bar chart that
>> > will show the grouped results of only the top 5 groups (ideally by the
>> > sum of the entire date range) and a summation of all other groups.
>> > Showing all the groups makes the chart illegible.
>> > The input data is a variable number of groups and different group
>> > titles, depending on user selection. I currently have a chart that is
>> > using the Optional Y Series Grouping and sorting by quantum, but can't
>> > find a way to only show top 5 groups.
>> > I'm using BIRT 3.7.2
>> >
>> > All thoughts and ideas welcome!
>> > Thanks for the help
>
>
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889257 is a reply to message #888994] |
Tue, 19 June 2012 04:12 |
|
This is most likely because the filter is happening before the
aggregation. Take a look at the topn example attached that aggregates
in the data set and then filters on the chart.
Jason
On 6/18/2012 5:24 PM, Ronan Murphy wrote:
> I have tried that and had some issues. My chart is set up as:
> X-axis: dates
> Y-axis: sales volume (integer)
> Y-Grouping: product (string) (Sorted descending on sales volume)
>
> I have the filter set up on Product - Top n - report parameter (integer)
>
> However this always gives me a single Product category rather than top
> 5. I also tried it unsorted and get same result.
>
> Will the top n filter also give me (or is it possible to include) a
> summation of all the categories that are not in the top 5? As we are
> looking at percentage area charts we would misrepresent the data
> otherwise, and it is an important element of the report.
>
> Apologies if it is a rudimentary question, I'm new to the program!
> Thanks again
>
>
>
> Jason Weathersby wrote on Mon, 18 June 2012 16:51
>> Have you tried to use a top N filter on the chart?
>>
>> Jason
>>
>> On 6/18/2012 1:18 PM, Ronan Murphy wrote:
>> > Hi all,
>> >
>> > I'm trying to create a percentage area chart or stacked bar chart that
>> > will show the grouped results of only the top 5 groups (ideally by the
>> > sum of the entire date range) and a summation of all other groups.
>> > Showing all the groups makes the chart illegible.
>> > The input data is a variable number of groups and different group
>> > titles, depending on user selection. I currently have a chart that is
>> > using the Optional Y Series Grouping and sorting by quantum, but can't
>> > find a way to only show top 5 groups.
>> > I'm using BIRT 3.7.2
>> >
>> > All thoughts and ideas welcome!
>> > Thanks for the help
>
>
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889261 is a reply to message #888994] |
Tue, 19 June 2012 04:12 |
|
This is most likely because the filter is happening before the
aggregation. Take a look at the topn example attached that aggregates
in the data set and then filters on the chart.
Jason
On 6/18/2012 5:24 PM, Ronan Murphy wrote:
> I have tried that and had some issues. My chart is set up as:
> X-axis: dates
> Y-axis: sales volume (integer)
> Y-Grouping: product (string) (Sorted descending on sales volume)
>
> I have the filter set up on Product - Top n - report parameter (integer)
>
> However this always gives me a single Product category rather than top
> 5. I also tried it unsorted and get same result.
>
> Will the top n filter also give me (or is it possible to include) a
> summation of all the categories that are not in the top 5? As we are
> looking at percentage area charts we would misrepresent the data
> otherwise, and it is an important element of the report.
>
> Apologies if it is a rudimentary question, I'm new to the program!
> Thanks again
>
>
>
> Jason Weathersby wrote on Mon, 18 June 2012 16:51
>> Have you tried to use a top N filter on the chart?
>>
>> Jason
>>
>> On 6/18/2012 1:18 PM, Ronan Murphy wrote:
>> > Hi all,
>> >
>> > I'm trying to create a percentage area chart or stacked bar chart that
>> > will show the grouped results of only the top 5 groups (ideally by the
>> > sum of the entire date range) and a summation of all other groups.
>> > Showing all the groups makes the chart illegible.
>> > The input data is a variable number of groups and different group
>> > titles, depending on user selection. I currently have a chart that is
>> > using the Optional Y Series Grouping and sorting by quantum, but can't
>> > find a way to only show top 5 groups.
>> > I'm using BIRT 3.7.2
>> >
>> > All thoughts and ideas welcome!
>> > Thanks for the help
>
>
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889265 is a reply to message #888994] |
Tue, 19 June 2012 04:12 |
|
This is most likely because the filter is happening before the
aggregation. Take a look at the topn example attached that aggregates
in the data set and then filters on the chart.
Jason
On 6/18/2012 5:24 PM, Ronan Murphy wrote:
> I have tried that and had some issues. My chart is set up as:
> X-axis: dates
> Y-axis: sales volume (integer)
> Y-Grouping: product (string) (Sorted descending on sales volume)
>
> I have the filter set up on Product - Top n - report parameter (integer)
>
> However this always gives me a single Product category rather than top
> 5. I also tried it unsorted and get same result.
>
> Will the top n filter also give me (or is it possible to include) a
> summation of all the categories that are not in the top 5? As we are
> looking at percentage area charts we would misrepresent the data
> otherwise, and it is an important element of the report.
>
> Apologies if it is a rudimentary question, I'm new to the program!
> Thanks again
>
>
>
> Jason Weathersby wrote on Mon, 18 June 2012 16:51
>> Have you tried to use a top N filter on the chart?
>>
>> Jason
>>
>> On 6/18/2012 1:18 PM, Ronan Murphy wrote:
>> > Hi all,
>> >
>> > I'm trying to create a percentage area chart or stacked bar chart that
>> > will show the grouped results of only the top 5 groups (ideally by the
>> > sum of the entire date range) and a summation of all other groups.
>> > Showing all the groups makes the chart illegible.
>> > The input data is a variable number of groups and different group
>> > titles, depending on user selection. I currently have a chart that is
>> > using the Optional Y Series Grouping and sorting by quantum, but can't
>> > find a way to only show top 5 groups.
>> > I'm using BIRT 3.7.2
>> >
>> > All thoughts and ideas welcome!
>> > Thanks for the help
>
>
|
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889844 is a reply to message #889787] |
Tue, 19 June 2012 21:43 |
|
Ronan,
There are other ways around this all though it may involve a bit of
scripting. In fact you can replace all of the data a chart uses at run
time. I am not certain you want to do this. If you need some kind of
example let me know. BTW pie charts have min slice value that combines
smaller values into a "others" type category as well.
Jason
On 6/19/2012 11:14 AM, Ronan Murphy wrote:
> Jason,
>
> That makes sense and when I checked it is the issue. Unfortunately I'm
> complicating this as I'm working off a database join and need the extra
> column that would be aggregated out to do the join on.
>
> Sounds like I'll need to find another approach to present the data.
>
> Thanks for the help
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889845 is a reply to message #889844] |
Tue, 19 June 2012 21:48 |
|
BTW another more elegant solution is to create a birt data cube off of
the data set and then drag the cube to the report. Ann a filter to it
and then convert it to a chart view. Take a look at the attached example.
Jason
On 6/19/2012 5:43 PM, Jason Weathersby wrote:
> Ronan,
>
> There are other ways around this all though it may involve a bit of
> scripting. In fact you can replace all of the data a chart uses at run
> time. I am not certain you want to do this. If you need some kind of
> example let me know. BTW pie charts have min slice value that combines
> smaller values into a "others" type category as well.
>
> Jason
>
> On 6/19/2012 11:14 AM, Ronan Murphy wrote:
>> Jason,
>>
>> That makes sense and when I checked it is the issue. Unfortunately I'm
>> complicating this as I'm working off a database join and need the extra
>> column that would be aggregated out to do the join on.
>>
>> Sounds like I'll need to find another approach to present the data.
>>
>> Thanks for the help
>
|
|
|
Re: Area Chart - Only show top 5 and summation of remainder [message #889846 is a reply to message #889844] |
Tue, 19 June 2012 21:48 |
|
BTW another more elegant solution is to create a birt data cube off of
the data set and then drag the cube to the report. Ann a filter to it
and then convert it to a chart view. Take a look at the attached example.
Jason
On 6/19/2012 5:43 PM, Jason Weathersby wrote:
> Ronan,
>
> There are other ways around this all though it may involve a bit of
> scripting. In fact you can replace all of the data a chart uses at run
> time. I am not certain you want to do this. If you need some kind of
> example let me know. BTW pie charts have min slice value that combines
> smaller values into a "others" type category as well.
>
> Jason
>
> On 6/19/2012 11:14 AM, Ronan Murphy wrote:
>> Jason,
>>
>> That makes sense and when I checked it is the issue. Unfortunately I'm
>> complicating this as I'm working off a database join and need the extra
>> column that would be aggregated out to do the join on.
>>
>> Sounds like I'll need to find another approach to present the data.
>>
>> Thanks for the help
>
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04508 seconds