Hi!
I am trying to use Canvas to build a Dashboard to show the Metrics based on certain field availability.
Is it possible to use the exists function in essql? Or is there any alternative functions available to execute in essql?
SELECT AVG(METRICS-NAME) FROM index WHERE field_name exists and <other_conditions>
Note: I have tried the Kibana visualization - where "field exists" filter is available. But I would like to know we can use "exists" in Canvas.
Thank you!