It is possible to use Time filter with ElasticSQL on Canvas?

Elastic Stack Elasticsearch
1

I would like to filter a essql query the results using only time filter element from canvas, it's possible?

This is my ESsql

essql 
  query=" SELECT sum(venta) AS sum_total_venta FROM \"demo_finanzas_21\" WHERE divisas='USD' AND traders='Jessica Brown'"
| math "sum_total_venta"
| formatNumber "0.00a"
| metric 
  metricFont={font family="'Avenir', Helvetica, Arial, sans-serif" size=60 align="left" color="#444444" weight="normal" underline=false italic=false}
| render

This is my time filter

timefilterControl compact=true column="timestamp"
| render

2

the solution is simple add filters and | as follows:

filters
    | essql query=" SELECT sum(venta) AS sum_total_venta FROM \"demo_finanzas_21\" WHERE divisas='USD' AND traders='Jessica Brown'"
    | math "sum_total_venta"
    | formatNumber "0.00a"
    | metric 
      metricFont={font family="'Avenir', Helvetica, Arial, sans-serif" size=60 align="left" color="#444444" weight="normal" underline=false italic=false}
    | render
3

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