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

**URL:** <https://discuss.elastic.co/t/it-is-possible-to-use-time-filter-with-elasticsql-on-canvas/166976>\
**Category:** Elasticsearch\
**Created:** [February 4, 2019, 2:35pm UTC](https://discuss.elastic.co/t/it-is-possible-to-use-time-filter-with-elasticsql-on-canvas/166976 "2019-02-04T14:35:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Plazas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miguel_plazas/32/40038_2.png) [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\
**Post date:** [February 4, 2019, 2:35pm UTC](https://discuss.elastic.co/t/it-is-possible-to-use-time-filter-with-elasticsql-on-canvas/166976/1 "2019-02-04T14:35:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Miguel\_Plazas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miguel_plazas/32/40038_2.png) [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\
**Post date:** [February 5, 2019, 8:37pm UTC](https://discuss.elastic.co/t/it-is-possible-to-use-time-filter-with-elasticsql-on-canvas/166976/2 "2019-02-05T20:37:55Z")

</div>

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

---

<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:** [March 5, 2019, 8:37pm UTC](https://discuss.elastic.co/t/it-is-possible-to-use-time-filter-with-elasticsql-on-canvas/166976/3 "2019-03-05T20:37:57Z")

</div>

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