# Visualise data filtered by time

**URL:** <https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831>\
**Category:** Kibana\
**Created:** [November 29, 2018, 10:16pm UTC](https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831 "2018-11-29T22:16:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![javidr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/javidr/32/136982_2.png) [@javidr](https://discuss.elastic.co/u/javidr)\
**Post date:** [November 29, 2018, 10:16pm UTC](https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831/1 "2018-11-29T22:16:07Z")

</div>

Hi

I have a temperature sensor and i am feeding elasticsearch the data that consists in timestamp, humidity and temperature

I want to generate a graph that displays as a line chart the temperature in the y axis and the timestamp in the x axis. Something like this

![35](https://us1.discourse-cdn.com/elastic/original/3X/e/6/e6166eaa14b0c4ad892fa0b78998642d59d0a174.png)

Looks pretty trivial and basic but i am not able to generate that visualisation

On x axis i have date histogram, thats clear. But on y axis, what should i set?

Thanks

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [November 29, 2018, 11:11pm UTC](https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831/2 "2018-11-29T23:11:57Z")

</div>

For the y-axis you can choose average temperature, which should basically accomplish what you're asking. Currently, there is no way to visualize individual documents inside your dataset, only aggregate data.

---

<div class="post-metadata">

**Author:** ![bryan\_stuhlsatz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bryan_stuhlsatz/32/49123_2.png) [@bryan\_stuhlsatz](https://discuss.elastic.co/u/bryan_stuhlsatz)\
**Post date:** [December 2, 2018, 7:34am UTC](https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831/3 "2018-12-02T07:34:25Z")

</div>

If you choose a custom time for your date histogram, and make it a smaller bucket than your data collection interval, then it will display your exact data values. Always be aware of the data collection interval, and what display problem you are trying to solve (ex. the max value of a field).

You can also add 2 aggregations and show your temperature and your humidity on the same graph (one on the left, and one on the right).

---

<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:** [December 30, 2018, 7:34am UTC](https://discuss.elastic.co/t/visualise-data-filtered-by-time/158831/4 "2018-12-30T07:34:34Z")

</div>

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