# Data \[All message fields \] are not visible on kibana 7 to drill down on pie chart

**URL:** https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708
**Category:** Kibana
**Created:** [September 2, 2019, 2:51pm UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708 "2019-09-02T14:51:36Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Milind\_Kaklij](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/milind_kaklij/32/53449_2.png) [@Milind\_Kaklij](https://discuss.elastic.co/u/Milind_Kaklij)
#### Post date: [September 2, 2019, 2:51pm UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708/1 "2019-09-02T14:51:37Z")

</div>

Hi Experts,  
I am using kibana-7.3.1 .My custom JSON gets stored in elastic search inside 'message' field,  
and I want to draw pie chart based on these fields .but issue is I can't see those custom JSON fields on KIBANA dashboard for selection ,Can anyone guide me on same?

Thanks.

---

<div class="post-metadata">

### Author: ![monfera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/monfera/32/26467_2.png) [@monfera](https://discuss.elastic.co/u/monfera)
#### Post date: [September 2, 2019, 8:01pm UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708/2 "2019-09-02T20:01:46Z")

</div>

You could convert the strings into real document structures, eg. using the `grok` processor in the ingest pipeline [https://www.elastic.co/guide/en/elasticsearch/reference/master/grok-processor.html](https://www.elastic.co/guide/en/elasticsearch/reference/master/grok-processor.html)

A more targeted approach is the JSON preprocessor in Logstash [https://www.elastic.co/guide/en/logstash/current/plugins-filters-json.html](https://www.elastic.co/guide/en/logstash/current/plugins-filters-json.html)

---

<div class="post-metadata">

### Author: ![Milind\_Kaklij](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/milind_kaklij/32/53449_2.png) [@Milind\_Kaklij](https://discuss.elastic.co/u/Milind_Kaklij)
#### Post date: [September 3, 2019, 8:43am UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708/3 "2019-09-03T08:43:05Z")

</div>

Thank you very much @monfera for suggesting approach.  
I am new to logstash. Could you please provide any reference/sample JSON preprocessor example in Logstash which will give expected format to index in elasticsearch.

Thanks.

---

<div class="post-metadata">

### Author: ![monfera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/monfera/32/26467_2.png) [@monfera](https://discuss.elastic.co/u/monfera)
#### Post date: [September 3, 2019, 10:21am UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708/4 "2019-09-03T10:21:09Z")

</div>

There are a bunch of examples [here](https://www.elastic.co/guide/en/logstash/current/plugins-filters-json.html) and setting up logstash is described [here](https://www.elastic.co/guide/en/logstash/current/setup-logstash.html) and there are various blog posts and tutorials if you search, maybe worth searching or asking in Logstash discuss as it's not really Kibana-specific.

---

<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: [October 1, 2019, 10:21am UTC](https://discuss.elastic.co/t/data-all-message-fields-are-not-visible-on-kibana-7-to-drill-down-on-pie-chart/197708/5 "2019-10-01T10:21:15Z")

</div>

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