Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Minimum slice in chart(Possible to apply same in a table?)
Minimum slice in chart [message #545679] Thu, 08 July 2010 15:04 Go to next message
Missing name Missing name is currently offline Missing name Missing nameFriend
Messages: 94
Registered: November 2009
Member
As title says, in a pie chart you can configure the chart to lump all the small sectors into one, usually called "Others". This is based on a percentage or value figure.
It is possible to do similar for tables, hopefully w/o scripting?

thanks
Re: Minimum slice in chart [message #545904 is a reply to message #545679] Fri, 09 July 2010 14:49 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Trevor,

I just posted an example that I think will help you. Take a look at it:
http://www.birt-exchange.org/org/devshare/designing-birt-rep orts/1239-minimum-group-report/

Jason

On 7/8/2010 11:04 AM, TREVOR.HIGGINS@FINEOS.COM wrote:
> As title says, in a pie chart you can configure the chart to lump all
> the small sectors into one, usually called "Others". This is based on a
> percentage or value figure. It is possible to do similar for tables,
> hopefully w/o scripting?
>
> thanks
Re: Minimum slice in chart [message #545921 is a reply to message #545679] Fri, 09 July 2010 15:30 Go to previous messageGo to next message
Missing name Missing name is currently offline Missing name Missing nameFriend
Messages: 94
Registered: November 2009
Member
Hi Jason,
Thanks for that, sounds interesting.....would it be possible to post a report using that script snippet as i'm not seeing exactly how it hangs together on its own.

From my understanding that will change the label if the condition is < 5000. It wont change the grouping

e.g. Currently I have
Value      Count
Val1         60
Val2         30
Val3          4
Val4          3
Val5          3

I would like this to only show a row if its % is 5% or more of the total, so I would like to see

Value      Count
Val1       60
Val2       30
Others     10

but using your example I get 

Value      Count
Val1        60
Val2        30
Others       4
Others       3
Others       3


thanks
Trevor

[Updated on: Fri, 09 July 2010 15:38]

Report message to a moderator

Re: Minimum slice in chart [message #545925 is a reply to message #545921] Fri, 09 July 2010 15:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Trevor,

Did you download the report? The script snippet is the group expression.

Jason

On 7/9/2010 11:30 AM, TREVOR.HIGGINS@FINEOS.COM wrote:
> Hi Jason,
> Thanks for that, sounds interesting.....would it be possible to report
> using that script snippet as i'm not seeing exactly how it hangs
> together on its own.
>
> thanks
> Trevor
Re: Minimum slice in chart [message #545926 is a reply to message #545925] Fri, 09 July 2010 15:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I just noticed that the report did not get attached. I just re-uploaded
it. Can you try again?

Jason

On 7/9/2010 11:35 AM, Jason Weathersby wrote:
> Trevor,
>
> Did you download the report? The script snippet is the group expression.
>
> Jason
>
> On 7/9/2010 11:30 AM, TREVOR.HIGGINS@FINEOS.COM wrote:
>> Hi Jason,
>> Thanks for that, sounds interesting.....would it be possible to report
>> using that script snippet as i'm not seeing exactly how it hangs
>> together on its own.
>>
>> thanks
>> Trevor
>
Re: Minimum slice in chart [message #545932 is a reply to message #545926] Fri, 09 July 2010 15:54 Go to previous messageGo to next message
Missing name Missing name is currently offline Missing name Missing nameFriend
Messages: 94
Registered: November 2009
Member
Yeah like I was saying above, that report seems to replace the label with "Other" but I would like to lump all the rows that qualify to be part of "Other" and have just the one row for them (similar to what we can do with a pie chart).
The label would be "Other" obviously and the value would be the sum of values from the contained rows.

Does that make sense, not sure if i'm explaining it well?

[Updated on: Fri, 09 July 2010 16:01]

Report message to a moderator

Re: Minimum slice in chart [message #545940 is a reply to message #545932] Fri, 09 July 2010 16:20 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Trevor

I think. Why not add an aggregation element to the group footer that
sums priceeach * qtyordered and aggregate on the group and then just
hide the detail row?

Jason

On 7/9/2010 11:54 AM, TREVOR.HIGGINS@FINEOS.COM wrote:
> Yeah like I was saying above, that report seems to replace the label
> with "Other" but I would like to lump all the rows that qualify to be
> part of "Other" and have just the one row for them. The label would be
> "Other" obviously and the value would be the sum of values from the
> contained rows.
>
> Does that make any sense?
Previous Topic:XML Data Source: Where the XML comes from
Next Topic:Fixed number of characters in column
Goto Forum:
  


Current Time: Fri Mar 29 00:12:19 GMT 2024

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

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

Back to the top