# How to display elasticsearch data Difference graph

**URL:** <https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087>\
**Category:** Elasticsearch\
**Created:** [November 20, 2019, 6:57am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087 "2019-11-20T06:57:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![nakarkashi](https://avatars.discourse-cdn.com/v4/letter/n/278dde/32.png) [@nakarkashi](https://community.grafana.com/u/nakarkashi)\
**Post date:** [November 20, 2019, 6:57am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/1 "2019-11-20T06:57:26Z")

</div>

Hi,  
I have some number data collected every day from elasticseach  
I have a question

・ How to get and draw difference data for each day

ex)  
November1  
HOST A:100  
HOST B:300  
November2  
HOST A:120  
HOST B:280  
Graph show November2  
⇒HOST A:20  
HOST A:-20

elasticsearch:6.6.1  
grafana:6.4.3

---

<div class="post-metadata">

**Author:** ![gretamosa](https://avatars.discourse-cdn.com/v4/letter/g/5f8ce5/32.png) [@gretamosa](https://community.grafana.com/u/gretamosa)\
**Post date:** [November 20, 2019, 7:38am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/2 "2019-11-20T07:38:13Z")

</div>

You should use another datasource such as [Metaqueries](https://grafana.com/grafana/plugins/goshposh-metaqueries-datasource/installation).

---

<div class="post-metadata">

**Author:** ![nakarkashi](https://avatars.discourse-cdn.com/v4/letter/n/278dde/32.png) [@nakarkashi](https://community.grafana.com/u/nakarkashi)\
**Post date:** [November 20, 2019, 8:58am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/3 "2019-11-20T08:58:40Z")

</div>

Thanks.

Investigate and use Metaqueries if necessary

---

<div class="post-metadata">

**Author:** ![nakarkashi](https://avatars.discourse-cdn.com/v4/letter/n/278dde/32.png) [@nakarkashi](https://community.grafana.com/u/nakarkashi)\
**Post date:** [November 21, 2019, 5:41am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/4 "2019-11-21T05:41:14Z")

</div>

After examining Metaqueries, the following URL was found.  
It seems that the previous day’s data can be displayed in TimeShift, but it does not seem to be able to arithmetic calculations based on that data.  
Is there any solution?

> **[GoshPosh/grafana-meta-queries](https://github.com/GoshPosh/grafana-meta-queries)**
>
> Grafana plugin for calculating time period metrics like week over week, month over month and year over year etc. - GoshPosh/grafana-meta-queries

  
「TimeShift on arithmetic is not supported」

---

<div class="post-metadata">

**Author:** ![fadjar340](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/fadjar340/32/10236_2.png) [@fadjar340](https://community.grafana.com/u/fadjar340)\
**Post date:** [April 11, 2020, 11:48am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/5 "2020-04-11T11:48:13Z")

</div>

Try CompareQueries Datasource

> **[GitHub - AutohomeCorp/autohome-compareQueries-datasource: This plugin is...](https://github.com/AutohomeCorp/autohome-compareQueries-datasource)**
>
> This plugin is built as a datasource plugin that comapre and contrasts different time shifts data - GitHub - AutohomeCorp/autohome-compareQueries-datasource: This plugin is built as a datasource pl...

 ![image](https://us1.discourse-cdn.com/grafana/original/2X/6/6e1aa4fdd5eabdcc9b6206a7324b7d3ed7e2c548.png)

Fadjar Tandabawana

---

<div class="post-metadata">

**Author:** ![leoswing](https://avatars.discourse-cdn.com/v4/letter/l/5f9b8f/32.png) [@leoswing](https://community.grafana.com/u/leoswing)\
**Post date:** [July 24, 2026, 3:01am UTC](https://community.grafana.com/t/how-to-display-elasticsearch-data-difference-graph/23087/6 "2026-07-24T03:01:08Z")

</div>

Hi, try to use the Grafana compare plugin with more powerful Alerting, Expression, Ad-Hoc filter support. Details: [GitHub - leoswing/comparequeries-datasource-rc: Grafana plugin for time-shifted query comparison across datasources · GitHub](https://github.com/leoswing/comparequeries-datasource-rc)

Hope you would benefit from this plugin, Star 🌟 this github project if you found it usedul ~ Thanks a lot