Canvas use of Gauge and drop down menus

Elastic Stack Kibana
1

Hi !
I'm trying to use a gauge combined with a Drop-down Filter in Kibana Canvas Workpad.
Both the drop down and the gauge work perfectly separately : i can update some meters with my drop down filter, and my gauge has the right percentage when nothing is selected inside the drop down filter.

However, my problem appears when I try to use both together: apparently the change in the drop down menu only affect the nominator (my first essql query) and not the denominator of the gauge.

How can I force the application of the filter also on the denominator ?

kibana
| selectFilter
| essql 
  query="SELECT count(se) as Operationals FROM \"status-*\" WHERE (serviceStatus = 'IN_SERVICE' OR serviceStatus = 'SUSPENDED')
  AND NOT manualStatus ='FREEZE' AND (generalStatus= 'Available' OR generalStatus='Occupied')  AND \"@timestamp\" >= NOW() - INTERVAL 15 MINUTE"
| math {string "Operationals /" {filters | essql query="SELECT count(se) as Parc FROM \"status-*\" WHERE (serviceStatus = 'IN_SERVICE' OR serviceStatus = 'SUSPENDED')
  AND not manualStatus ='FREEZE' AND \"@timestamp\" >= NOW() - INTERVAL 15 MINUTE" | math " Parc"}}
| progress shape="gauge" label={formatnumber "0.000%"} 
  font={font size=24 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"}
| render

I already tried to force the filter with group = "dropdownfilter1" after "SelectFilter" at the beginning and after "filters" inside my math expression and the only thing I succeeded at was to block all influence the drop down filter has on my gauge which is a really sad solution...

If anyone has an idea, thanks for the help !

2

I found a solution ! If anyone has the same problem as me here is how I solved it :

kibana
| selectFilter 
| var_set name="Ope" value={essql "SELECT count(se) as Ope FROM \"status-*\" WHERE (serviceStatus = 'IN_SERVICE' OR serviceStatus = 'SUSPENDED')
  AND NOT manualStatus ='FREEZE' AND (generalStatus= 'Available' OR generalStatus='Occupied')   AND \"@timestamp\" >= NOW() - INTERVAL 15 MINUTE"}
| var_set name="Parc" value={essql "SELECT count(se) as Parc FROM \"status-*\" WHERE (serviceStatus = 'IN_SERVICE' OR serviceStatus = 'SUSPENDED')
  AND not manualStatus ='FREEZE' AND \"@timestamp\" >= NOW() - INTERVAL 15 MINUTE"}
| createTable ids="totalA" ids="totalB"
| staticColumn name="totalA" value={var "Ope" | getCell "Ope"}
| alterColumn column="totalA" type="number"
| staticColumn name="totalB" value={var "Parc" | getCell "Parc"}
| alterColumn column="totalB" type="number"
| mathColumn id="percent" name="percent" expression="totalA / totalB"
| math "percent"
| progress shape="gauge" label={formatnumber "0.000%"} 
  font={font size=24 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"}
| render

When creating variables apparently the filter is really applied (and not when adding an Essql query as I did in the first place)