Canvas Charts Limiting Results

Elastic Stack Kibana
1

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?

2

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

Thanks,
Bhavya

3

Still needing any suggestions on this.

4

@Tim_Mobley The ESSql function used in Canvas defaults to only fetching 1000 docs. You can set a "count" argument on the function in the expression to fetch up to 10000 docs.

5

Is 10,000 the limit then?

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.