Preset Feature Feedback
What is the problem or goal the end user is trying to solve or accomplish?
The customer wants to create a dynamic bar chart that shows only the top N categories based on the "Total Value" (e.g., sum(sales)) while displaying all associated sub-categories. They need this functionality to be responsive to time filters, allowing the chart to automatically adjust which categories are displayed based on the filtered data.
How are they solving it currently?
The customer has tried using the Series Limit function in Preset, which limits the number of sub-categories but does not restrict the categories themselves based on a dynamic metric. Other workarounds include using custom SQL queries or multiple visualizations, which adds complexity and reduces flexibility, especially when dealing with varying sub-categories.
What is the recommended solution by the Customer?
The customer would like a feature that dynamically limits the top N categories based on "Total Value" while displaying all sub-categories within those categories. The feature should work seamlessly with existing filters, such as date filters, and should not require manual pre-filtering or complex SQL queries.
