Limit Bar Chart to top N values

Hey everyone,

I write raw SQL queries to visualize data from my DB. My data have often multiple rows that would be overkill to preview in Charts, therefore, I apply LIMIT to my SQL queries.

However, I want to be able to download all data as CSV, not only the data that pass the LIMIT.

Is there any way to apply LIMIT only to Bar Chart (e.g. top 20), leaving the SQL query without limit?

I’m using ‘Group by’ terms and then choosing Top. It defaults to top 10 but you can make it any number you want.