This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

[Interface] Group limits on bar chart

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator
Status: New Ideas
What is the proposed idea/solution?

For bar charts, where we can group field summaries, I propose the ability to limit them to "top x" where x is a custom number field.

How does this solve the user problems?

If there are a lot of records at play during grouping, then grouping field summaries do not visually work.

For example below is a bar chart where:

  • y-axis is the total number of pre-orders
  • x-axis is the release date months
  • the chart shows the sum of different orders
  • it is grouped by brands


Ideally, if I want to only see the top 5 brands pre-ordered that month, I would input "top 5" so there would only be five bars, and the rest are "others." Additionally, it would be great to have the groups sorted in ascending or descending order by aggregate or alphabetically.

It's best if we can limit it to what we think is aesthetically plausible.

How was this validated?

Grouping is dependent on the field summary's aggregate. If we can limit lookup fields to last x or first x, I think this should be possible too.

Who is the target audience?

Interface users. People who like charts.