|
|
Re: Minimum slice in chart [message #545921 is a reply to message #545679] |
Fri, 09 July 2010 15:30 |
Missing name Missing name 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 |
|
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 |
|
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 |
Missing name Missing name 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 |
|
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?
|
|
|
Powered by
FUDForum. Page generated in 0.23605 seconds