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.