# DATEDIFF EQUIVALENT

**URL:** <https://discuss.elastic.co/t/datediff-equivalent/197701>\
**Category:** Elasticsearch\
**Created:** [September 2, 2019, 2:13pm UTC](https://discuss.elastic.co/t/datediff-equivalent/197701 "2019-09-02T14:13:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![charlinhos](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@charlinhos](https://discuss.elastic.co/u/charlinhos)\
**Post date:** [September 2, 2019, 2:13pm UTC](https://discuss.elastic.co/t/datediff-equivalent/197701/1 "2019-09-02T14:13:49Z")

</div>

I’ve been using elasticsearch to store data and kibana to create dashboards.

I want to visualize in the dashboard the date difference between different rows.

In the panel above, there is an example of what rows are returned when I search for the account “997838579”

I want to know if there is a way to add a visualization to my dashboard to see the time difference between the rows returned by my search .

Example: Add a visualization to the dashboard showing the time difference between the row where the status\_code is “N” and the row where the status\_code is “I”

 ![print](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d4434321360bc3bed93a189bb5f4730b98e3d2ec.jpeg)

---

<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:** [September 30, 2019, 2:13pm UTC](https://discuss.elastic.co/t/datediff-equivalent/197701/2 "2019-09-30T14:13:50Z")

</div>

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