Charts and Too Many Smaller Values

[jamesh]

Have you ever charted more than six values in one Pie Chart?  In one of my Pie Charts, things were fine while I had only four totals showing up from my primary Group.Ã,  But as I expanded the data range to include more data, more totals appeared and cluttered my pie chart with slices too small to see.

In a version 7 demo, I thought I saw a way to consolidate those smaller pieces into a "Misc." or "All Others" catagory.Ã,  But in version 5, I can't seem to find any such thing.Ã,  Is there a way in version 5 to consolidate totals from a Group conditionally, perhaps when their % of the whole drops below a certain value, say 10%?

[jamesh]

I just looked into Impromptu version 6.0 and there's no noticable changes in the charting features between 5 and 6.  So version 6 is not the answer, apparently.

Would anyone who has version 7 be willing to try this scenario for me and see if they have an option to consolidate smaller values?

[jamesh]

In studying this issue further, the Summary RANK might be able to isolate the Top values into calculated fields.  But the issue with Pie charts is that they can only display results from one column (field).  Is there a way to combine multiple columns into one?

[turnonthejets]

I would setup a calculation (% total) to determine the percentage of total for each customer.  Then a second calculation (large customers) that looks something like this

if ( [% total] > .1 ) then ( [Customer Column] ) else ( 'Other' )

Now group the large customers column rather than your acutal Customer column.  This will put all the customers with less than 10% into one grouping.  Then chart away.  Hope this helps.