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?


Still needing any suggestions on this.

@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.

Is 10,000 the limit then?

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