i need to visualize 2 dependent fields in one diagram such that the following simple scenario is fulfilled:
for every message in response, field "f1" is unique but field "f2" could be repetitive. Then the goal is to display the average value of "f1" per "f2". IOW, i'm looking for a way to group "f1" based on "f2".
Sounds like you're looking for the Average Aggregation. Here's an example of the Data Table visualization showing an average of "f2" for each unique "f1":
@Larry_Gregory tnx a lot.
My only question is that what type of fields could be included in the first combobox, where u selected f2. As I can't see my own f2 and some other fields in the combobox.
You'll only be able to take an average against a numeric field. If you inspect your index mapping, it will tell you which data type each field is indexed as.
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.