Kibana Canvas expression

Hi, please, I have 2 questions:

  1. what is the difference between
filters

and

selectFilter

In Kibana 8.4 seems like filter is not working anymore:

and question no2:

Can I have two occurances of selectFilter within one expression?
like this?

kibana 
|selectFilter  group="by-device" group="by-date1" ungrouped=false
| essql query= "SELECT Round(AVG(\"P1-C01-Temp\"),2) as P1C01_T, 
                       Round(AVG(\"P1-C02-Temp\"),2) as P1C02_T, 
                       Round(AVG(\"P1-C03-Temp\"),2) as P1C03_T, 
                       Round(AVG(\"P1-C04-Temp\"),2) as P1C04_T,
                       Round(STDDEV_POP(\"P1-C01-Temp\"),2) as P1C01_STD,
                       Round(STDDEV_POP(\"P1-C02-Temp\"),2) as P1C02_STD,
                       Round(STDDEV_POP(\"P1-C03-Temp\"),2) as P1C03_STD,
                       Round(STDDEV_POP(\"P1-C04-Temp\"),2) as P1C04_STD
                       FROM \"metrics-factory*\" WHERE \"prodTimeSpan\"=0"
| var_set name="a01" value={getCell "P1C01_T"}
| var_set name="a02" value={getCell "P1C02_T"}
| var_set name="a03" value={getCell "P1C03_T"}
 var_set name="a04" value={getCell "P1C04_T"}
 var_set name="s01" value={getCell "P1C01_STD"}
| var_set name="s02" value={getCell "P1C02_STD"}
| var_set name="s03" value={getCell "P1C03_STD"}
| var_set name="s04" value={getCell "P1C04_STD"}
|selectFilter  group="by-device" group="by-date2" ungrouped=false
|essql query= "SELECT Round(AVG(\"P1-C01-Temp\"),2) as P1C01_T, 
                       Round(AVG(\"P1-C02-Temp\"),2) as P1C02_T, 
                       Round(AVG(\"P1-C03-Temp\"),2) as P1C03_T, 
                       Round(AVG(\"P1-C04-Temp\"),2) as P1C04_T,
                       Round(STDDEV_POP(\"P1-C01-Temp\"),2) as P1C01_STD,
                       Round(STDDEV_POP(\"P1-C02-Temp\"),2) as P1C02_STD,
                       Round(STDDEV_POP(\"P1-C03-Temp\"),2) as P1C03_STD,
                       Round(STDDEV_POP(\"P1-C04-Temp\"),2) as P1C04_STD
                       FROM \"metrics-factory*\" WHERE \"prodTimeSpan\"=0"
| var_set name="a201" value={getCell "P1C01_T"}
| var_set name="s201" value={getCell "P1C01_STD"}
| markdown "|   AVG1     |   STD1     | 
|-------------|-------------|
| " {var "a01"} " | "  {var "s01"} "   | 
| " {var "a02"} " | "  {var "s02"} "    | 
| " {var "a03"} " | "  {var "s03"} "  |  
 " {var "a04"} " | "  {var "s04"} "  | 
  " {var "a201"} " | "  {var "s201"} "  |"                  
| render

I cant figure this out too and also none of the options work in 8.4!

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