Canvas Charts Limiting Results

I am using an Elasticsearch SQL query in a horizontal bar chart in Kibana. At the end of my query I have LIMIT ALL, which should return all results that match the WHERE statement. Discover shows 292,589 hits for the same query, however the chart shows only 1,000 results. Where/how do I change this setting to have it show all results?

@corey.robertson / @Catherine_Liu can we please get some help here?

Thanks,
Bhavya