This Product Ideas board is currently undergoing updates, but please continue to submit your 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.
