Hi, ist there any way how to share queries in Kibana's Canvas between elements?
I have cca 200 elements, some of them with Histogram query, some of them using histogram query result as input parameter for where clausule in Average aggregation essql query as subqueries are not supported. Now I am evaluating the same histogram for each element and then using result of this histogram result as variable parameter for average result, and that is 200queries where 1 would be enough..I am thinking about shared query, shared variable, whatever...is there any best practice for this?
As datetimeFilter control's UP/DOWN control sends request on each change, it is more than 300requests per second ...
Thanks a lot, I lost already several days with this:(