Why does my report show an 'Other' category in the chart ?
|Knowledge Article Number||000025251|
|Description||Why does my report show an 'Other' category in the chart ?|
|Resolution||When you create reports that contain charts, the information will create chart segments for all values that are more than 3% of the grand total.
If you have any information that is less than 3% of the grand total, it will be grouped in to the "other" category and added to the chart.
For example in a report that is summarizing Opportunities by Region the region "New England" will be displayed in a chart in the "Other" grouping and not as "New England" if it represents 2.42% of the total of the report. This is because this figure is less than 3% of the total report.
The "Other" grouping may also be a combination of multiple items that are less than 3% of the total. Using the above example New England at 2.42% and Canada at 0.61% would both be included in the "Other" category as they are less than 3% of the total for the report. This would display the "Other" group as 3.1% (rounded).
if the chart type is pie, donut, or funnel then unchecking the format option "Combine Small Groups into Others" will remove the Other category.