# Identify the difference in data for two successive days

**URL:** <https://discuss.elastic.co/t/identify-the-difference-in-data-for-two-successive-days/363131>\
**Category:** Elasticsearch\
**Created:** [July 15, 2024, 9:45am UTC](https://discuss.elastic.co/t/identify-the-difference-in-data-for-two-successive-days/363131 "2024-07-15T09:45:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lshmikanth](https://avatars.discourse-cdn.com/v4/letter/l/e47774/32.png) [@lshmikanth](https://discuss.elastic.co/u/lshmikanth)\
**Post date:** [July 15, 2024, 9:45am UTC](https://discuss.elastic.co/t/identify-the-difference-in-data-for-two-successive-days/363131/1 "2024-07-15T09:45:04Z")

</div>

I have a query which gives the tabular data on the key value pairs. I want to analyse the same query for two successive days and find out the new additions or deletions from the key values in the table. Any option available in Elasticsearch. Please help

---

<div class="post-metadata">

**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\
**Post date:** [July 15, 2024, 12:48pm UTC](https://discuss.elastic.co/t/identify-the-difference-in-data-for-two-successive-days/363131/2 "2024-07-15T12:48:13Z")

</div>

> [@lshmikanth](#):
>
> I have a query which gives the tabular data on the key value pairs. I want to analyse the same query for two successive days and find out the new additions or deletions from the key values in the table. Any option available in Elasticsearch. Please help

Hello @lshmikanth ,

Can you provide some examples of records and how you want to compare them to illustrate your problem?

---

<div class="post-metadata">

**Author:** ![lshmikanth](https://avatars.discourse-cdn.com/v4/letter/l/e47774/32.png) [@lshmikanth](https://discuss.elastic.co/u/lshmikanth)\
**Post date:** [July 15, 2024, 3:53pm UTC](https://discuss.elastic.co/t/identify-the-difference-in-data-for-two-successive-days/363131/3 "2024-07-15T15:53:10Z")

</div>

Thank you Alex. Sample data as below.This table will be built every data as a report. If there are additions or deletions from list I want to know the difference

Column 1 | Column 2 | Column 3  
|--- | --- | --- | ---|  
|AAA | APP1 | 1195 | |  
|BBB | APP2 | 892 | |  
|CCC | APP3 | 638 | |