# How to do a line graph of mean data?

**URL:** https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173
**Category:** Kibana
**Created:** [March 27, 2017, 5:49pm UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173 "2017-03-27T17:49:29Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![pbData](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@pbData](https://discuss.elastic.co/u/pbData)
#### Post date: [March 27, 2017, 5:49pm UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173/1 "2017-03-27T17:49:29Z")

</div>

I am currently trying to graph some data(totalProcessingTime) in a line graph. You can see this from the table of raw data. I would like to graph the raw data or its mean value. Unfortunately all I can seem to visualise is the count. Can someone please demonstrate how I can achieve this.

PS - I know this is really old version of kibana but the system that creates the data uses a older version of elastic search too and I cant change this!

 ![](https://us1.discourse-cdn.com/elastic/original/3X/3/d/3dff8ec15bf5849112391b68b24531be98c704b9.PNG)

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [March 28, 2017, 5:32pm UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173/2 "2017-03-28T17:32:05Z")

</div>

Click the little gear icon at the top of the histogram and change the mode from "count" to "mean"

---

<div class="post-metadata">

### Author: ![pbData](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@pbData](https://discuss.elastic.co/u/pbData)
#### Post date: [March 28, 2017, 6:10pm UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173/3 "2017-03-28T18:10:11Z")

</div>

Thanks for replying. I have tried that and it doesn't show anything. From memory the reload icon just twirls around too.

---

<div class="post-metadata">

### Author: ![pbData](https://avatars.discourse-cdn.com/v4/letter/p/d2c977/32.png) [@pbData](https://discuss.elastic.co/u/pbData)
#### Post date: [March 29, 2017, 7:24am UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173/4 "2017-03-29T07:24:55Z")

</div>

From the histogram settings, when I click the 'chart value' and select 'max' or 'mean' another box open named 'Value field' appears. I have entered the field totalProcessingTime(full name starts with log-example....). when I do this I get an exception, from what I remember! When I start typing the only field that appears is '\_type'! Hope someone can help.

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

---

<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: [April 26, 2017, 7:25am UTC](https://discuss.elastic.co/t/how-to-do-a-line-graph-of-mean-data/80173/5 "2017-04-26T07:25:05Z")

</div>

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