STUMPER: Pre-solved Q&A to sharpen your TBM and Apptio skills.

Solution posted in 7 days if nobody submits a correct answer.

See title for rating: [+] Easy   [++] Moderate   [+++] Challenging

I've been working on a server report. One of its components is this pie chart:

So far so good--except for that (Other) category in gray.

When I highlight the pie chart, I see this as its configuration dialog:

That field in the Values area is a metric called Server Count.

Here are its details as seen from the Metrics tab:

This metric's Value Calculation formula references the Server Count column in the Servers Master Data set.

As it turns out, this column's value is being set in the master data set's mapping configuration area:

Its value is being set to 1 for every row in the Servers Master Data set.

And finally, if I head to the Data tab, select the Servers Master Data set, right-click the Location column and select Show Unique Values, I see:

...in other words, every row in this data table has a unique Location value.

No {Various} or Other or (Other) or anything like that.

I want to see all 14 categories in my pie chart.
Why am I seeing (Other) in the chart, and how can I get rid of it?

This is related to the report component properties where the # of rows and "display other" options can be set.  The "display other" property can be turned off and then the component will just show "top x" values, where "x" is the number of rows set in the property.

Correct.

When I right-clicked the pie chart and selected Properties > Data, I saw:

I changed the 6 to an arbitrarily large number: 99

...and now my pie chart includes all values - and the (Other) section is gone:

I'm not sure if I like the new look, though. I might revert back to my original version.

You mentioned the ability to toggle the "Other" row on or off using a report component property.

Selecting Ribbon > Data > Sum > Show Other Row lets us do this - but for all ad-hoc tables and chart types except pie charts.

For pie charts, this menu option is grayed out:

Not a problem though - changing the maximum rows was all I needed in this case.

You're on fire, answering all of these questions, John!

this gamification works on me