Hello all, i'm trying to do a pie chart in Kibana dashboard based on some data i have. I don't understand if i am missing something or is Kibana that just works differently.
I would like, given a time interval, to draw a pie chart based on sums of every field. So for example given period 2020-12-01 2020-12-03 i have pc=66, smartphones=149, tablets=12 so the pie chart would have 3 slices (pc=29%, smartphones=65%, tablets=6%)
I'm trying to do it but with no results. Is there something that i miss? thanks
Kibana's pie chart metric is based on a single field -- with your current document structure, it's going to be difficult to achieve what you are looking to do, because you want to look at the sum of 3 different fields.
However, if your documents were structured so that each category of thing you want to count is a separate document, you should be able to achieve what you're looking for more easily.
Then in your pie chart you could do a sum aggregation on the total, and split the slices using a terms aggregation on the type, which I believe would achieve what you're looking for.
Thank you very much, i knew that something was wrong with my docs format. I re-populate my index with some data and then try again with your indications. I will also give you a feedback on what i'll achieve...thanks again
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.