# Limit by charts

**URL:** <https://community.noloco.io/t/limit-by-charts/1488>\
**Category:** Ask for Help\
**Created:** [November 27, 2024, 4:52pm UTC](https://community.noloco.io/t/limit-by-charts/1488 "2024-11-27T16:52:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [November 27, 2024, 4:52pm UTC](https://community.noloco.io/t/limit-by-charts/1488/1 "2024-11-27T16:52:39Z")

</div>

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.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/d/de38152b7008775e52d90e1369dbae5f40c870c7.png)

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