Hi, i want to do aggregation on a field which has values like doc1_field: "A" doc2_field: "A, B" doc3_field: "A, B, C" What mappings / settings I can use so that when I aggregate on this field I should get results like: key: A count: 3 key: "B" count: 2 key: "C" count: 3 I have tried add…

This is more an Elasticsearch question but I think you need to ingest that fiel with actual separated values or maybe use an ingest pipeline to split it. The actual root cause is that tweaking the analizer will help you for searching but for aggregating you need to use a keyword field that contains …

Consider comma separated values in a field as separate values while aggregating

Elastic Stack Elasticsearch

system (system) Closed November 29, 2023, 4:27am 4

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

Topic		Replies	Views
Elasticsearch Java api split a field Elasticsearch	2	756	July 5, 2017
Aggregation on comma separated text field Kibana	2	2412	March 13, 2017
Unable to aggregate based on comma sepperated values Elasticsearch	2	811	October 1, 2017
Term Aggregate on Analyzed Fields? Elasticsearch	2	417	July 6, 2017
Faceted search aggregation single text field separated values Elasticsearch	2	348	February 8, 2019

Consider comma separated values in a field as separate values while aggregating

Related topics