# Visualize data with kibana

**URL:** <https://discuss.elastic.co/t/visualize-data-with-kibana/130967>\
**Category:** Kibana\
**Created:** [May 8, 2018, 9:41am UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967 "2018-05-08T09:41:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yoyo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yoyo/32/30922_2.png) [@yoyo](https://discuss.elastic.co/u/yoyo)\
**Post date:** [May 8, 2018, 9:41am UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967/1 "2018-05-08T09:41:42Z")

</div>

I want to create pie chart wich contains sum of text of each query but kibana show me this message

 ![elasticparse](https://us1.discourse-cdn.com/elastic/original/3X/0/f/0f772409c30878049b12db476522f0df7868c25f.png)  
 ![visualize](https://us1.discourse-cdn.com/elastic/original/3X/1/0/1069876c5ceb2dfe5a190c89b451eb6852434dd1.png)

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [May 8, 2018, 11:01am UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967/2 "2018-05-08T11:01:50Z")

</div>

are you sure you have data in the selected time range ? (time picer top right)

could you open spy panel (up arrow at the bottom of chart) and copy paste es request and resposne ?

---

<div class="post-metadata">

**Author:** ![yoyo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yoyo/32/30922_2.png) [@yoyo](https://discuss.elastic.co/u/yoyo)\
**Post date:** [May 9, 2018, 1:47pm UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967/3 "2018-05-09T13:47:12Z")

</div>

Request : {  
"version": true,  
"size": 500,  
"sort": [  
{  
"@timestamp": {  
"order": "desc",  
"unmapped\_type": "boolean"  
}  
}  
],  
"\_source": {  
"excludes": []  
},  
"aggs": {  
"2": {  
"date\_histogram": {  
"field": "@timestamp",  
"interval": "30s",  
"time\_zone": "Africa/Lagos",  
"min\_doc\_count": 1  
}  
}  
},  
"stored\_fields": [  
"_"  
],  
"script\_fields": {},  
"docvalue\_fields": [  
"@timestamp",  
"ts"  
],  
"query": {  
"bool": {  
"must": [  
{  
"match\_all": {}  
},  
{  
"range": {  
"@timestamp": {  
"gte": 1525872285062,  
"lte": 1525873185062,  
"format": "epoch\_millis"  
}  
}  
}  
],  
"filter": [],  
"should": [],  
"must\_not": []  
}  
},  
"highlight": {  
"pre\_tags": [  
"@kibana-highlighted-field@"  
],  
"post\_tags": [  
"@/kibana-highlighted-field@"  
],  
"fields": {  
"_": {}  
},  
"fragment\_size": 2147483647  
}  
}  
Response:  
{  
"took": 22,  
"hits": {  
"hits": [  
{  
"\_index": "yos",  
"\_type": "test",  
"\_id": "OaoVRWMBJkgbPPM80hXe",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"path": "/home/yosra/ELK2/logstash-6.2.2/test4.log",  
"thread": "CRA\_GENERATION\_THREADS-263",  
"@version": "1",  
"message": "Dec 18, 2017 18:14:44:251 |Pal : TRACE |Persistence-[CRA\_GENERATION\_THREADS-263]: COR:vm2: ElapsedTime for Query Execution 4 milliseconds.",  
"text": 4,  
"host": "yosra",  
"@timestamp": "2018-05-09T13:27:28.021Z",  
"ts": "2017-12-18T17:14:44.251Z",  
"query": "Find query : : ( select T.type , T.id , T.groupeType , T.updatorUserId , T.fessAmount , T.currency$identifier , T.maxAmount , T.feeTypeIndex , T.fixedFeesAmount , T.feesRate , T.updateDate , T.version , T.creationDate , T.creatorUserId , T.localTaxeOnFeesAmount , T.isForcedFees , T.isCdscFee , T.localTaxeOnFeesRate from models\_Fees T left join T.orderOPC as T0 where T0.caceisReference = ?1 ) "  
},  
"fields": {  
"@timestamp": [  
"2018-05-09T13:27:28.021Z"  
],  
"ts": [  
"2017-12-18T17:14:44.251Z"  
]  
},  
"sort": [  
1525872448021  
]  
},  
{  
"\_index": "yos",  
"\_type": "test",  
"\_id": "OqoVRWMBJkgbPPM80hXh",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"path": "/home/yosra/ELK2/logstash-6.2.2/test4.log",  
"thread": "CRA\_GENERATION\_THREADS-262",  
"@version": "1",  
"message": "Dec 18, 2017 18:14:44:249 |Pal : TRACE |Persistence-[CRA\_GENERATION\_THREADS-262]: COR:vm2: ElapsedTime for Query Execution 1 milliseconds.",  
"text": 1,  
"host": "yosra",  
"@timestamp": "2018-05-09T13:27:28.020Z",  
"ts": "2017-12-18T17:14:44.249Z",  
"query": "Find query : : ( select T.type , T.id , T.groupeType , T.updatorUserId , T.fessAmount , T.currency$identifier , T.maxAmount , T.feeTypeIndex , T.fixedFeesAmount , T.feesRate , T.updateDate , T.version , T.creationDate , T.creatorUserId , T.localTaxeOnFeesAmount , T.isForcedFees , T.isCdscFee , T.localTaxeOnFeesRate from models\_Fees T left join T.orderOPC as T0 where T0.caceisReference = ?1 ) "  
},  
"fields": {  
"@timestamp": [  
"2018-05-09T13:27:28.020Z"  
],  
"ts": [  
"2017-12-18T17:14:44.249Z"  
]  
},  
"sort": [  
1525872448020  
]  
},  
{  
"\_index": "yos",  
"\_type": "test",  
"\_id": "OKoVRWMBJkgbPPM80hXX",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"path": "/home/yosra/ELK2/logstash-6.2.2/test4.log",  
"thread": "CRA\_GENERATION\_THREADS-262",  
"@version": "1",  
"message": "Dec 18, 2017 18:14:44:248 |Pal : TRACE |Persistence-[CRA\_GENERATION\_THREADS-262]: COR:vm2: ElapsedTime for Query Execution 2 milliseconds.",  
"text": 2,  
"host": "yosra",  
"@timestamp": "2018-05-09T13:27:28.019Z",  
"ts": "2017-12-18T17:14:44.248Z",  
"query": "Find query : : ( select T.flot , T.id , T.groupeType , T.updatorUserId , T.fessAmount , T.currency$identifier , T.maxAmount , T.feeTypeIndex , T.fixedFeesAmount , T.feesRate , T.updateDate , T.version , T.creationDate , T.creatorUserId , T.localTaxeOnFeesAmount , T.isForcedFees , T.isCdscFee , T.localTaxeOnFeesRate from models\_Fees T left join T.orderOPC as T0 where T0.caceisReference = ?1 ) "  
},  
"fields": {  
"@timestamp": [  
"2018-05-09T13:27:28.019Z"  
],  
"ts": [  
"2017-12-18T17:14:44.248Z"  
]  
},  
"sort": [  
1525872448019  
]  
}  
],  
"total": 3,  
"max\_score": 0  
},  
"aggregations": {  
"2": {  
"buckets": [  
{  
"key\_as\_string": "2018-05-09T14:27:00.000+01:00",  
"key": 1525872420000,  
"doc\_count": 3  
}  
]  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![yoyo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yoyo/32/30922_2.png) [@yoyo](https://discuss.elastic.co/u/yoyo)\
**Post date:** [May 9, 2018, 3:45pm UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967/4 "2018-05-09T15:45:29Z")

</div>

when I reduce the size of query in the log , it works  
what's the problem?  
thank you

 ![short](https://us1.discourse-cdn.com/elastic/original/3X/4/e/4e8d7466b63accbc9b4cf7d60cf6207756591ad1.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:** [June 6, 2018, 3:45pm UTC](https://discuss.elastic.co/t/visualize-data-with-kibana/130967/5 "2018-06-06T15:45:34Z")

</div>

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