# Compare fields and report

**URL:** <https://discuss.elastic.co/t/compare-fields-and-report/322468>\
**Category:** Kibana\
**Created:** [January 4, 2023, 1:48pm UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468 "2023-01-04T13:48:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pclokcer](https://avatars.discourse-cdn.com/v4/letter/p/d9b06d/32.png) [@pclokcer](https://discuss.elastic.co/u/pclokcer)\
**Post date:** [January 4, 2023, 1:48pm UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/1 "2023-01-04T13:48:45Z")

</div>

example data

```auto
{
 "timestamp": "2023-01-04T14:00:00.00Z",
 "url": "http://localhost/test",
 "trace_id": "asdasdasd"
}

{
 "timestamp": "2023-01-04T14:01:00.000Z",
 "url": "http://localhost/test",
 "trace_id": "asdasdasd"
}

```

I want to compare two data and see to table like this

```auto
url | trace_id | response time
------------------------------------------------------------------------------------------------
http://localhost/test | asdasdasd | 60 second

```

How can I report like this ?

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 4, 2023, 4:16pm UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/2 "2023-01-04T16:16:32Z")

</div>

Hi Erdam,

I presume [http://localhost/test](http://localhost/test) might have more than two entries in your logs. Are you only looking to get the response time from the latest two entries?

---

<div class="post-metadata">

**Author:** ![pclokcer](https://avatars.discourse-cdn.com/v4/letter/p/d9b06d/32.png) [@pclokcer](https://discuss.elastic.co/u/pclokcer)\
**Post date:** [January 5, 2023, 10:18am UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/3 "2023-01-05T10:18:01Z")

</div>

Hi,

I want to take first and last entry. because I need to see response time.

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 5, 2023, 3:59pm UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/4 "2023-01-05T15:59:22Z")

</div>

HI Erdem.

There is currently no out-of-the-box way to do this in Kibana or Elasticsearch. There is a history of discussions on this, especially in [this thread](https://discuss.elastic.co/t/using-painless-to-calculate-durations/119495).

I would recommend finding a way to calculate the elapsed time at ingest. The [Logstash Elapsed filter plugin](https://www.elastic.co/guide/en/logstash/current/plugins-filters-elapsed.html) is a good example of this.

---

<div class="post-metadata">

**Author:** ![pclokcer](https://avatars.discourse-cdn.com/v4/letter/p/d9b06d/32.png) [@pclokcer](https://discuss.elastic.co/u/pclokcer)\
**Post date:** [January 6, 2023, 7:39am UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/5 "2023-01-06T07:39:46Z")

</div>

Hi,

thank you for interest me

---

<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:** [February 3, 2023, 7:40am UTC](https://discuss.elastic.co/t/compare-fields-and-report/322468/6 "2023-02-03T07:40:06Z")

</div>

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