Create a Top 5 chart and "others" category

Hi all:

I want to create a top X chart using a dimension or custom field including an “others” category with the sum of the rest of the values.

For example

Thanks

Hi @walterdp,

To create such a chart, place the desired dimension in report rows and select the members in the dimension “All hierarchy level members”. Select the measure you want to use and click on its header. In the menu, select the “Top rows” option, then “N rows” and “5”. See the example below:

Next, select the “All others” option in the report toolbar and switch to the “Bar” chart view:

See our documentation page for more details - Create reports.

Best,
Roberts // support@eazybi.com

1 Like