# How to visualize a simple query

**URL:** <https://discuss.elastic.co/t/how-to-visualize-a-simple-query/82917>\
**Category:** Kibana\
**Created:** [April 19, 2017, 4:05pm UTC](https://discuss.elastic.co/t/how-to-visualize-a-simple-query/82917 "2017-04-19T16:05:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jspooner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jspooner/32/12984_2.png) [@jspooner](https://discuss.elastic.co/u/jspooner)\
**Post date:** [April 19, 2017, 4:05pm UTC](https://discuss.elastic.co/t/how-to-visualize-a-simple-query/82917/1 "2017-04-19T16:05:16Z")

</div>

I'm looking at your [moving averages](https://www.elastic.co/guide/en/elasticsearch/reference/5.3/search-aggregations-pipeline-movavg-aggregation.html) reference and would like an easy way to run similar queries and have the results graphed. Kibana gives me these options

1. The console in DevTools is the ideal query writing tool however you can only view JSON results.
2. The Visualize tab gives you the ability to produce many graphs but your limited to building queries with their form. And I don't see moving avg as an option in its form.
3. Timelion, ok we do options for moving averages but I need to write JSON queries.

So is there a way to write JSON queries and visualize the results in Kibana? The graphs in these [articles](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-movavg-aggregation.html) appear to be from kibana.

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [April 19, 2017, 9:58pm UTC](https://discuss.elastic.co/t/how-to-visualize-a-simple-query/82917/2 "2017-04-19T21:58:13Z")

</div>

Hi @jspooner,

you'll be able to make visualizations with the moving average aggregation, starting from the next minor Kibana release 5.4.

You'll be able to do this in the Visualize application for regular line and bar charts: cf: [https://github.com/elastic/kibana/issues/11339](https://github.com/elastic/kibana/issues/11339)

5.4 also introduces the Time Series Visual Builder, a new UI for creating a time series visualization. This one too gives you access to the Moving Average metric: [https://github.com/elastic/kibana/pull/9725](https://github.com/elastic/kibana/pull/9725)

---

<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:** [May 17, 2017, 10:08pm UTC](https://discuss.elastic.co/t/how-to-visualize-a-simple-query/82917/3 "2017-05-17T22:08:54Z")

</div>

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