Canvas - Variable in essql

Elastic Stack Kibana
1

Im trying to use the canvas variables, i have managed to get it working via text/markdown, i am trying to use it within an essql statement, heres my example

WHERE \"@timestamp\" > TODAY() - INTERVAL 30 DAY AND organization.name=\"" {var 'Org'} "\"

and also tried

WHERE \"@timestamp\" > TODAY() - INTERVAL 30 DAY AND organization.name=\"" {var "Org"} "\"

Any suggestions?
Ive also created a dropdown filter, i get the correct info in the drop down, again same field, organization.name. How do i get that filter to apply to Kibana elements? Or if its possible to use the variable on the kibana elements

2

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