Is it possible to use field exists Canvas essql?

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!

Hi

what about using where <fieldname> is not null?

Hi There!

Thanks a lot for sharing this. Lately, we managed to check the field which contains blank value. Tried the other way, where "<fieldname>"='' and the condition worked as expected.

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