# Kibana essql query date diff

**URL:** https://discuss.elastic.co/t/kibana-essql-query-date-diff/271483
**Category:** Kibana
**Tags:** canvas
**Created:** [April 28, 2021, 8:28am UTC](https://discuss.elastic.co/t/kibana-essql-query-date-diff/271483 "2021-04-28T08:28:53Z")
**Posts on this page:** 1
**Showing post:** 15

<div class="post-metadata">

### Author: ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)
#### Post date: [May 15, 2021, 9:37am UTC](https://discuss.elastic.co/t/kibana-essql-query-date-diff/271483/15 "2021-05-15T09:37:52Z")

</div>

Hi Felix,  
I already tried the sort function....nothing change.

Current situation:

 ![Cattura1](https://us1.discourse-cdn.com/elastic/original/3X/5/c/5cd88b2652f0d4ee12e5f98f7005f725d73d9598.png)  
 ![Cattura2](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9a757e48a3f5b54c24c72995586e2966ec830be9.png)

with expression:

```auto
filters group="group3" ungrouped=true
| essql 
  query="SELECT DAY(date) as dd, MIN(date) as realDate, DATE_DIFF('hours',MIN(date),MAX(date)) as diff FROM \"application_data_bridgenuzoo\" GROUP BY DAY(date)"
| mapColumn name="formatted_date" expression={getCell "realDate" | formatdate format="DD/MM/YY"}
| pointseries x="formatted_date" y="diff"
| plot defaultStyle={seriesStyle bars=0.75 lines="1"}
| render

```

I tried also:

```auto
filters group="group3" ungrouped=true
| essql 
  query="SELECT DAY(date) as dd, MIN(date) as realDate, DATE_DIFF('hours',MIN(date),MAX(date)) as diff FROM \"application_data_bridgenuzoo\" GROUP BY DAY(date)"
| mapColumn name="formatted_date" expression={getCell "realDate" | formatdate format="DD/MM/YY"}
| pointseries x="formatted_date" y="diff"
| sort by="x" reverse=false
| plot defaultStyle={seriesStyle bars=0.75 lines="1"}
| render

```

with and without reverse...nothing.  
I tried:

```auto
filters group="group3" ungrouped=true
| essql 
  query="SELECT DAY(date) as dd, MIN(date) as realDate, DATE_DIFF('hours',MIN(date),MAX(date)) as diff FROM \"application_data_bridgenuzoo\" GROUP BY MONTH(date)"
| mapColumn name="formatted_date" expression={getCell "realDate" | formatdate format="DD/MM/YY"}
| pointseries x="formatted_date" y="diff"
| plot defaultStyle={seriesStyle bars=0.75 lines="1"}
| render

```

but I have a error:

```
Found 1 problem line 1:8: Cannot use non-grouped column [date], expected [MONTH(date)]

```

I tried all...

---

_[View the full topic](https://discuss.elastic.co/t/kibana-essql-query-date-diff/271483)._