Hi, please, I have 2 questions:
- 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