I'm new here so I'm not sure if this is the best place for this. I'm new to using the Canvas feature in Kibana. I'm using essql SELECT requests like:
SELECT * from index
but I'm only returned the first 1000 documents by default. I can change this by setting
count = 10000
but that's as far as I can go, and it is slow to generate a plot. I noticed that Visualizations (bar charts for instance) created in the "Visualize" tab use all of the data in my index (roughly 700,000 records). Is there a way to use ALL of my data in Canvas? Otherwise, I don't know how to create meaningful metrics here that reflect all of my data.