# Average in heat map visualization is 0

**URL:** <https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449>\
**Category:** Kibana\
**Created:** [August 21, 2018, 7:08pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449 "2018-08-21T19:08:24Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![masyutka](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@masyutka](https://discuss.elastic.co/u/masyutka)\
**Post date:** [August 21, 2018, 7:08pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/1 "2018-08-21T19:08:24Z")

</div>

Hi experts!

I have the following 3 values in the index in discover  
Time serverDelay\_median scenarioName  
July 8th 2018, 00:00:00.000 0.707 OPEN\_WOC\_PEOPLE  
July 8th 2018, 00:00:00.000 0.743 OPEN\_WOC\_PEOPLE  
July 8th 2018, 00:00:00.000 0.763 OPEN\_WOC\_PEOPLE

When i try to aggregate over them in visualization it give me 0 for the average of serverDelay\_median.  
Any idea why? this is coming in response itself (so not a visual problem)

REQUEST:

{  
"size": 0,  
"\_source": {  
"excludes": []  
},  
"aggs": {  
"2": {  
"date\_histogram": {  
"field": "day",  
"interval": "1d",  
"time\_zone": "UTC",  
"min\_doc\_count": 1  
},  
"aggs": {  
"3": {  
"terms": {  
"field": "scenarioName",  
"size": 5,  
"order": {  
"1": "desc"  
}  
},  
"aggs": {  
"1": {  
"avg": {  
"field": "serverDelay\_median"  
}  
}  
}  
}  
}  
}  
},  
"stored\_fields": [  
"\*"  
],  
"script\_fields": {},  
"docvalue\_fields": [  
"day"  
],  
"query": {  
"bool": {  
"must": [  
{  
"match\_all": {}  
},  
{  
"match\_phrase": {  
"serverDelay\_outlier": {  
"query": 1  
}  
}  
},  
{  
"match\_phrase": {  
"scenarioName": {  
"query": "OPEN\_WOC\_PEOPLE"  
}  
}  
},  
{  
"range": {  
"day": {  
"gte": 1531008000000,  
"lte": 1531094399999,  
"format": "epoch\_millis"  
}  
}  
}  
],  
"filter": [],  
"should": [],  
"must\_not": []  
}  
}  
}

RESPONSE:  
{  
"took": 0,  
"timed\_out": false,  
"\_shards": {  
"total": 1,  
"successful": 1,  
"skipped": 0,  
"failed": 0  
},  
"hits": {  
"total": 3,  
"max\_score": 0,  
"hits": []  
},  
"aggregations": {  
"2": {  
"buckets": [  
{  
"3": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"1": {  
"value": 0  
},  
"key": "OPEN\_WOC\_PEOPLE",  
"doc\_count": 3  
}  
]  
},  
"key\_as\_string": "2018-07-08 00:00:00",  
"key": 1531008000000,  
"doc\_count": 3  
}  
]  
}  
},  
"status": 200  
}

I looked at similar topics like  
[https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/13](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/13)  
and

> <https://github.com/elastic/kibana/issues/4736>

  
but nothing works.

---

<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:** [August 21, 2018, 8:09pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/2 "2018-08-21T20:09:25Z")

</div>

Hmm, it looks like the response from elasticsearch itself is coming back as a zero. Could you provide your mapping as well as the raw json from the docs in question? Thanks!

---

<div class="post-metadata">

**Author:** ![masyutka](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@masyutka](https://discuss.elastic.co/u/masyutka)\
**Post date:** [August 22, 2018, 1:09am UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/3 "2018-08-22T01:09:38Z")

</div>

Here is mapping: (now i wonder is it because its integer?)

{  
"pkh\_outliers": {  
"mappings": {  
"\_doc": {  
"properties": {  
"area": {  
"type": "keyword"  
},  
"baseline\_release": {  
"type": "keyword"  
},  
"browserDelay\_baseline": {  
"type": "integer"  
},  
"browserDelay\_mean": {  
"type": "integer"  
},  
"browserDelay\_median": {  
"type": "integer"  
},  
"browserDelay\_outlier": {  
"type": "integer"  
},  
"browserDelay\_std": {  
"type": "integer"  
},  
"browserDelay\_var": {  
"type": "integer"  
},  
"clientDelay\_baseline": {  
"type": "integer"  
},  
"clientDelay\_mean": {  
"type": "integer"  
},  
"clientDelay\_median": {  
"type": "integer"  
},  
"clientDelay\_outlier": {  
"type": "integer"  
},  
"clientDelay\_std": {  
"type": "integer"  
},  
"clientDelay\_var": {  
"type": "integer"  
},  
"count": {  
"type": "integer"  
},  
"cycleRel": {  
"type": "keyword"  
},  
"day": {  
"type": "date",  
"format": "yyyy-MM-dd HH:mm:ss"  
},  
"networkDelay\_baseline": {  
"type": "integer"  
},  
"networkDelay\_mean": {  
"type": "integer"  
},  
"networkDelay\_median": {  
"type": "integer"  
},  
"networkDelay\_outlier": {  
"type": "integer"  
},  
"networkDelay\_std": {  
"type": "integer"  
},  
"networkDelay\_var": {  
"type": "integer"  
},  
"noBaseline": {  
"type": "integer"  
},  
"noRoundTrips\_baseline": {  
"type": "integer"  
},  
"noRoundTrips\_mean": {  
"type": "integer"  
},  
"noRoundTrips\_median": {  
"type": "integer"  
},  
"noRoundTrips\_outlier": {  
"type": "integer"  
},  
"noRoundTrips\_std": {  
"type": "integer"  
},  
"noRoundTrips\_var": {  
"type": "integer"  
},  
"objectName": {  
"type": "keyword"  
},  
"overallOutlier": {  
"type": "integer"  
},  
"scenarioName": {  
"type": "keyword"  
},  
"serverDelay\_baseline": {  
"type": "integer"  
},  
"serverDelay\_mean": {  
"type": "integer"  
},  
"serverDelay\_median": {  
"type": "integer"  
},  
"serverDelay\_outlier": {  
"type": "integer"  
},  
"serverDelay\_std": {  
"type": "integer"  
},  
"serverDelay\_var": {  
"type": "integer"  
},  
"tti\_baseline": {  
"type": "integer"  
},  
"tti\_mean": {  
"type": "integer"  
},  
"tti\_median": {  
"type": "integer"  
},  
"tti\_outlier": {  
"type": "integer"  
},  
"tti\_std": {  
"type": "integer"  
},  
"tti\_var": {  
"type": "integer"  
},  
"uiTypeBrowser": {  
"type": "keyword"  
}  
}  
}  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![masyutka](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@masyutka](https://discuss.elastic.co/u/masyutka)\
**Post date:** [August 22, 2018, 1:09am UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/4 "2018-08-22T01:09:54Z")

</div>

Here are 3 JSONs:

{  
"\_index": "pkh\_outliers",  
"\_type": "\_doc",  
"\_id": "0RvySWUBpTZXMfucobOp",  
"\_score": 1,  
"\_source": {  
"cycleRel": "1811+C3",  
"uiTypeBrowser": "HTML+Internet Explorer",  
"area": "PLATFORM",  
"objectName": "ACCOUNT",  
"scenarioName": "OPEN\_WOC\_PEOPLE",  
"count": 6,  
"day": "2018-07-08 00:00:00",  
"clientDelay\_mean": 1.0118333333333334,  
"clientDelay\_median": 0.9804999999999999,  
"clientDelay\_var": 0.026287366666666683,  
"clientDelay\_std": 0.162133792488385,  
"tti\_mean": 1.0118333333333334,  
"tti\_median": 0.9804999999999999,  
"tti\_var": 0.026287366666666683,  
"tti\_std": 0.162133792488385,  
"browserDelay\_mean": 0.874,  
"browserDelay\_median": 0.812,  
"browserDelay\_var": 0.029658799999999992,  
"browserDelay\_std": 0.17221730458928913,  
"networkDelay\_mean": 0.13783333333333334,  
"networkDelay\_median": 0.121,  
"networkDelay\_var": 0.002002566666666667,  
"networkDelay\_std": 0.04475004655491061,  
"serverDelay\_mean": 0.7631666666666667,  
"serverDelay\_median": 0.707,  
"serverDelay\_var": 0.029785366666666667,  
"serverDelay\_std": 0.172584375499831,  
"noRoundTrips\_mean": 1,  
"noRoundTrips\_median": 1,  
"noRoundTrips\_var": 0,  
"noRoundTrips\_std": 0,  
"clientDelay\_outlier": 0,  
"clientDelay\_baseline": 0,  
"tti\_baseline": 0,  
"tti\_outlier": 0,  
"browserDelay\_outlier": 0,  
"browserDelay\_baseline": 0,  
"networkDelay\_outlier": 0,  
"networkDelay\_baseline": 0,  
"serverDelay\_outlier": 1,  
"serverDelay\_baseline": 0.5798275862068965,  
"noRoundTrips\_outlier": 0,  
"noRoundTrips\_baseline": 0,  
"noBaseline": 0,  
"overallOutlier": 1,  
"baseline\_release": "1808+C3"  
},  
"fields": {  
"day": [  
"2018-07-08T00:00:00.000Z"  
]  
}  
}

{  
"\_index": "pkh\_outliers",  
"\_type": "\_doc",  
"\_id": "CBvySWUBpTZXMfucobSp",  
"\_score": 1,  
"\_source": {  
"cycleRel": "1811+C3",  
"uiTypeBrowser": "HTML+Internet Explorer",  
"area": "PLATFORM",  
"objectName": "EMPLOYEE",  
"scenarioName": "OPEN\_WOC\_PEOPLE",  
"count": 6,  
"day": "2018-07-08 00:00:00",  
"clientDelay\_mean": 0.9889999999999999,  
"clientDelay\_median": 0.9854999999999999,  
"clientDelay\_var": 0.004212799999999997,  
"clientDelay\_std": 0.06490608600123718,  
"tti\_mean": 0.9889999999999999,  
"tti\_median": 0.9854999999999999,  
"tti\_var": 0.004212799999999997,  
"tti\_std": 0.06490608600123718,  
"browserDelay\_mean": 0.8438333333333333,  
"browserDelay\_median": 0.8354999999999999,  
"browserDelay\_var": 0.0013789666666666682,  
"browserDelay\_std": 0.0371344404383137,  
"networkDelay\_mean": 0.14516666666666667,  
"networkDelay\_median": 0.1265,  
"networkDelay\_var": 0.001714966666666666,  
"networkDelay\_std": 0.04141215602533471,  
"serverDelay\_mean": 0.7515000000000001,  
"serverDelay\_median": 0.743,  
"serverDelay\_var": 0.001737900000000003,  
"serverDelay\_std": 0.04168812780636716,  
"noRoundTrips\_mean": 1,  
"noRoundTrips\_median": 1,  
"noRoundTrips\_var": 0,  
"noRoundTrips\_std": 0,  
"clientDelay\_outlier": 0,  
"clientDelay\_baseline": 0,  
"tti\_baseline": 0,  
"tti\_outlier": 0,  
"browserDelay\_outlier": 0,  
"browserDelay\_baseline": 0,  
"networkDelay\_outlier": 0,  
"networkDelay\_baseline": 0,  
"serverDelay\_outlier": 1,  
"serverDelay\_baseline": 0.605970588235294,  
"noRoundTrips\_outlier": 0,  
"noRoundTrips\_baseline": 0,  
"noBaseline": 0,  
"overallOutlier": 1,  
"baseline\_release": "1808+C3"  
},  
"fields": {  
"day": [  
"2018-07-08T00:00:00.000Z"  
]  
}  
}

{  
"\_index": "pkh\_outliers",  
"\_type": "\_doc",  
"\_id": "bxvySWUBpTZXMfuck7Kq",  
"\_score": 1,  
"\_source": {  
"cycleRel": "1811+C3",  
"uiTypeBrowser": "HTML+Chrome",  
"area": "PLATFORM",  
"objectName": "ACCOUNT",  
"scenarioName": "OPEN\_WOC\_PEOPLE",  
"count": 5,  
"day": "2018-07-08 00:00:00",  
"clientDelay\_mean": 0.9774,  
"clientDelay\_median": 0.94,  
"clientDelay\_var": 0.013078800000000014,  
"clientDelay\_std": 0.11436258129300866,  
"tti\_mean": 0.9774,  
"tti\_median": 0.94,  
"tti\_var": 0.013078800000000014,  
"tti\_std": 0.11436258129300866,  
"browserDelay\_mean": 0.8218,  
"browserDelay\_median": 0.835,  
"browserDelay\_var": 0.002367199999999999,  
"browserDelay\_std": 0.0486538795986507,  
"networkDelay\_mean": 0.1556,  
"networkDelay\_median": 0.102,  
"networkDelay\_var": 0.007439800000000003,  
"networkDelay\_std": 0.08625427525636051,  
"serverDelay\_mean": 0.7462,  
"serverDelay\_median": 0.763,  
"serverDelay\_var": 0.002374699999999999,  
"serverDelay\_std": 0.04873089369178447,  
"noRoundTrips\_mean": 1,  
"noRoundTrips\_median": 1,  
"noRoundTrips\_var": 0,  
"noRoundTrips\_std": 0,  
"clientDelay\_outlier": 0,  
"clientDelay\_baseline": 0,  
"tti\_baseline": 0,  
"tti\_outlier": 0,  
"browserDelay\_outlier": 0,  
"browserDelay\_baseline": 0,  
"networkDelay\_outlier": 0,  
"networkDelay\_baseline": 0,  
"serverDelay\_outlier": 1,  
"serverDelay\_baseline": 0.6000333333333335,  
"noRoundTrips\_outlier": 0,  
"noRoundTrips\_baseline": 0,  
"noBaseline": 0,  
"overallOutlier": 1,  
"baseline\_release": "1808+C3"  
},  
"fields": {  
"day": [  
"2018-07-08T00:00:00.000Z"  
]  
}  
}

---

<div class="post-metadata">

**Author:** ![masyutka](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@masyutka](https://discuss.elastic.co/u/masyutka)\
**Post date:** [August 22, 2018, 3:26pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/5 "2018-08-22T15:26:27Z")

</div>

Hi Lukas, i changed to float and it works now, thank a lot for a hint !

---

<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:** [August 22, 2018, 3:46pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/6 "2018-08-22T15:46:36Z")

</div>

Glad you were able to figure it out! 😃

---

<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:** [September 19, 2018, 3:46pm UTC](https://discuss.elastic.co/t/average-in-heat-map-visualization-is-0/145449/7 "2018-09-19T15:46:38Z")

</div>

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