I want to see the aggregations combining both fields like
{"field3": ["a", "b", "c", "x", "y", "z"]}
If there is no direct way in kibana, can i use painless script to create new field for existing documents ? can someone provide me, to use in update_by_query ?
What you have there is aggregated data by itself. This is not what Kibana's Pie Chart uses. It does requests on non-aggregated data to Elasticsearch which then returns aggregated data to display. For this you could probably look into Canvas as it also has Pie Charts and it can use single documents as a source for it.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.