# Kibana Canvas expression

**URL:** <https://discuss.elastic.co/t/kibana-canvas-expression/316556>\
**Category:** Kibana\
**Created:** [October 13, 2022, 3:58pm UTC](https://discuss.elastic.co/t/kibana-canvas-expression/316556 "2022-10-13T15:58:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zdeno\_Liska](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zdeno_liska/32/83511_2.png) [@Zdeno\_Liska](https://discuss.elastic.co/u/Zdeno_Liska)\
**Post date:** [October 13, 2022, 3:58pm UTC](https://discuss.elastic.co/t/kibana-canvas-expression/316556/1 "2022-10-13T15:58:47Z")

</div>

Hi, please, I have 2 questions:

1. what is the difference between

```auto
filters

```

and

```auto
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?

```auto
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 "| &emsp; AVG1 &emsp; | &emsp;STD1 &emsp; | 
|-------------|-------------|
| " {var "a01"} " | " {var "s01"} " | 
| " {var "a02"} " | " {var "s02"} " | 
| " {var "a03"} " | " {var "s03"} " |  
 " {var "a04"} " | " {var "s04"} " | 
  " {var "a201"} " | " {var "s201"} " |"                  
| render

```

---

<div class="post-metadata">

**Author:** ![zx8086](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zx8086/32/94917_2.png) [@zx8086](https://discuss.elastic.co/u/zx8086)\
**Post date:** [October 13, 2022, 11:43pm UTC](https://discuss.elastic.co/t/kibana-canvas-expression/316556/2 "2022-10-13T23:43:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 10, 2022, 11:43pm UTC](https://discuss.elastic.co/t/kibana-canvas-expression/316556/3 "2022-11-10T23:43:54Z")

</div>

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