# Getting multiple data shown in 1 id

**URL:** <https://discuss.elastic.co/t/getting-multiple-data-shown-in-1-id/91422>\
**Category:** Elasticsearch\
**Created:** [June 30, 2017, 12:26pm UTC](https://discuss.elastic.co/t/getting-multiple-data-shown-in-1-id/91422 "2017-06-30T12:26:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Asztalos\_Ferenc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/asztalos_ferenc/32/19671_2.png) [@Asztalos\_Ferenc](https://discuss.elastic.co/u/Asztalos_Ferenc)\
**Post date:** [June 30, 2017, 12:26pm UTC](https://discuss.elastic.co/t/getting-multiple-data-shown-in-1-id/91422/1 "2017-06-30T12:26:15Z")

</div>

I'm using Elasticsearch with Grafana to store and visualize availability. I have a pre-made request, which has a response like this:

{"name":"Availability", "id":"197292", "report": {"availability": 996520, "start": 1498694400, "end": 1498780800, "sub": [{"av":1000000, "start":1498694400},{"av":1000000, "start":1498698000},{"av":1000000, "start":1498701600},{"av":1000000, "start":1498705200},{"av":1000000, "start":1498708800},{"av":912280, "start":1498712400},{"av":1000000, "start":1498716000},{"av":1000000, "start":1498719600},{"av":1000000, "start":1498723200},{"av":1000000, "start":1498726800},{"av":1000000, "start":1498730400},{"av":1000000, "start":1498734000},{"av":1000000, "start":1498737600},{"av":1000000, "start":1498741200},{"av":1000000, "start":1498744800},{"av":1000000, "start":1498748400},{"av":1000000, "start":1498752000},{"av":1000000, "start":1498755600},{"av":1000000, "start":1498759200},{"av":1000000, "start":1498762800},{"av":1000000, "start":1498766400},{"av":1000000, "start":1498770000},{"av":1000000, "start":1498773600},{"av":1000000, "start":1498777200}]}}

At first I set the timestamp to report.start, then I realized I could get use of the detailed log as well. I set the data to report.sub.start, which is also working fine, but all the "av" data is under 1 \_id.  
Now the problem is, that even though I set the timestamp correctly, I still get the average of the whole input. The data is there, because if I set Grafana from average to min or max, it's correct, simply I cannot visualize the change within the \_id.  
On the picture I have another graph with the same problem, don't bother with that.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/4/4/445925091e43abb5f765149f0568ed2490434bf3.png)

So the graph provides only the average of the 24 inputs, though as you can see, the availiability from hour to hour is mostly 100% with a 91,22% bottom.

---

<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:** [July 28, 2017, 12:26pm UTC](https://discuss.elastic.co/t/getting-multiple-data-shown-in-1-id/91422/2 "2017-07-28T12:26:17Z")

</div>

Closed on July 28, 2017, 12:26pm UTC

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