Hello, has anyone found a way to limit by in charts. I’m trying to create a pie chart to only show the Top 10 highest numbers but failing miserably. It shows all records, I cant set a filter as the data is dynamic and each user would have different scale.
The screenshot shows a relatively new staff members business, on older staff members the chart wont even load as there are so many entries meaning I cant really use it.
Think this would be helpful on all types of charts, I could create a mysql query but not the most efficient solution.
Thanks