I’ve got some data to graph on a pie chart.
Normally, I’ve only got 7 or 8 segments that will display on the pie, but in one instance I’ve got more like 22.
Of course, 22 values on a pie chart are not particularly useful…
So, is there a way to have the chart limit the data to the largest X values and group up the rest as “other”?
I’m looking and I don’t see one, but I thought I’d ask in any case. 
bbee (BOB member since 2010-03-09)
If you can determine a mininum amount you are willing to display and calculate a % based on that, possibly one way to get around this is to create a measure which includes all records greater than X% and everything else is “Other”
First create an object which calculates the % of [Your Object Name] and name it something like [% Your Object Name]
Then create an object that does something like this… (I used 50% as an example)
If(FormatNumber([% Your Object Name];"#,##0.00[%]%") >“50%”; [Your Object Name];“Other”)
Then create your chart on that new object.
REB01 
(BOB member since 2004-11-29)
Is it as simple as applying a top X ranking on your data table then turning it to a Pie Chart?
Nick Daniels 
(BOB member since 2002-08-15)
No, because applying the ranking would exclude any data that doesn’t fit. I want the data to show up in the graph, because I wouldn’t have a complete 100% allocation without it.
I just want to set a threshhold where anthing that isn’t in the top 8 locations (by transaction volume, amount, etc.) gets grouped up together instead of split out.
bbee (BOB member since 2010-03-09)
With that in mind, I believe your only option is to do something like I suggested in my earlier post. Determine the % that is in the top 8 (or whatever you determine to be the ideal number) and combine the rest.
Unfortunately, I can think of no other way to get what you need.
REB01 
(BOB member since 2004-11-29)
Get rid of the pie, they are next to useless anyway, one the most pointless ways of representing data there is, IMO 
.
Mak 1 
(BOB member since 2005-01-06)
But Mark, you know how some clients are… You can suggest alternatives all you want but “if they want pie, let them eat pie.” 
They (the client) will have it no other way. At least that has been my experience.
REB01 (BOB member since 2004-11-29)
Roland,
Correct :). However, I have managed to convince a couple by pointing them in the direction of Stephen Few:-
http://www.perceptualedge.com/
The Jedi master of dashboards / visulisations…
Cheers,
Mark.
Mak 1 (BOB member since 2005-01-06)
Fortunately, I was not asked to include a Pie specifically.
I think I will redo the chart by taking each range as a percentage of the total and graphing that on a bar chart. This would work especially well since my purpose is to compare the percentage of items submitted vs. a number of rejections.
bbee (BOB member since 2010-03-09)
You mean you chose it 
.
Mak 1 (BOB member since 2005-01-06)
um… temporary insanity? lol 
bbee (BOB member since 2010-03-09)
Allowed, just this once…;).
Check out the Stephen Few stuff, its good food for thought.
Mak 1 (BOB member since 2005-01-06)
Already did. Lot’s of good info there.
I was especially interested in the link he has on his current blog to tableau public: http://www.tableausoftware.com/public/
Watched the intro video there and checked out some of the other data presentations. WOW! That’s some amazing stuff… and free!
bbee (BOB member since 2010-03-09)
Cool, I was intoduced by a friend that went to one of his training sessions. I have known her for some time and have worked with her on a number of occassions.
He had some very interesting thoughts on the visual representation of reports too, it gave me plenty of ideas… 8) .
Mak 1 (BOB member since 2005-01-06)
Just had a look at this topic & am glad I did.
I’m sat here struggling with MapPoint 2010 Europe today (literally just got it and the only ‘update’ they’ve done to it appears to have been to make it more annoying than the prior version was to work with… 
) I just checked out this tableau link & demo video myself. Think I’ll be giving that a go at home tonight, looks awesome!
SteveD (BOB member since 2009-11-02)
bbee / Steve,
I hadn’t looked at the tableau stuff. Agreed, it looks real cool, will be looking at this further.
Cheers,
Mark.
Mak 1 (BOB member since 2005-01-06)