What is the problem or goal the end user is trying to solve or accomplish?
We would like to classify the categories with a smaller contribution value as "Others" on pie charts, and we want to be able to drill down to "Others" when clicking on it to explore the distribution with a smaller sample size.
How are they solving it currently?
We have a custom query configured in SQL lab which can label the values below a certain threshold (for example, lower than 2% contribution in the population) as "Others". But when users click on "Others" on the pie, it doesn't show them the granular breakdown of the values with smaller contributions.
We were able to perform this click-and-drilldown action in our previous BI tool, can Preset perform something similar too?