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
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?