Hi all,
I am trying to build a data table visualize so that show sum of my field named as "amount". for this purpose, i am trying to use sum aggregation in the metric part but i cannot find my field in the "field" part. it is noted that there are two "amount" fields as "amount" and "amount.keyword" that type of them are string. amount.keyword field is as following which it seems is aggregatable:
I cannot see neither "amount" nor "amount.keyword" in aggregation of visualize. how can i handle this issue? any advise will be so appreciated. Regards
They refer to the same data, they are just indexed in a different way. When you want to aggregate, amount.keyword is the right field to use - you can overwrite the shown name in the visualization.
I cannot see neither "amount" nor "amount.keyword" in aggregation of visualize
What aggregation are you trying to use? A keyword field can be used with "Unique count", "Terms" and "Significant terms"
You need to update existing documents by reindexing them into a new index with the correct mapping for the amount field. Check out the links I provided in my previous answer.
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.