Terms aggregation by field, but shows another field in Kibana

Elastic Stack Kibana
1

Hello,

I have the sample data below and i want to know if is it possible to make a Terms aggregation in Kibana by the field "codigo", but showing on the chart the field "nome".
For example, with the sample data below if we made that terms aggregation counting the number of records the result will be:

Maria do Joao - 1
Maria do Joao - 1
Maria do Joao - 1
Joaozinho da Maria - 1
Joaozinho da Maria - 1

When i made the terms aggregation in Kibana with the field "nome", the result is below, since the field "nome" has the same value.

Maria do Joao - 3
Joaozinho da Maria - 2

May you guys help me?

Thanks in advance!

Sample data:

PUT teste/_doc/1
{
	"codigo" : "0001"
	"nome" : "Maria do Joao"
	"tipo_parceiro" : "GOLD"
}
PUT teste/_doc/2
{
	"codigo" : "0002"
	"nome" : "Maria do Joao"
	"tipo_parceiro" : "GOLD"
}
PUT teste/_doc/3
{
	"codigo" : "0003"
	"nome" : "Maria do Joao"
	"tipo_parceiro" : "GOLD"
}
PUT teste/_doc/4
{
	"codigo" : "0004"
	"nome" : "Joaozinho da Maria"
	"tipo_parceiro" : "VIP"
}
PUT teste/_doc/5
{
	"codigo" : "0005"
	"nome" : "Joaozinho da Maria"
	"tipo_parceiro" : "VIP"
}
2

Hi,
Displaying values from a different field instead of the ID is not really possible in the normal visualizations for now. It's available as annotations in TSVB (visual builder), but that will require time series data.
You can add an enhancement request here: https://github.com/elastic/kibana/issues

3

Hello Marius!

Thanks for replying!

I've opened a feature request as below:

Thanks again!

4

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