Query visualization label from a different index

Elastic Stack Kibana
1

hi,
i want to create a visualization with a Top N items from a specific index, to the value of "item ID" which is a number, i have the item name and id in a different index.
can i change the item names to the fitting "item name" from the second index ? or is there a way to enrich the 1st index ?
what would be the best way ?

i am reading both of the indexes with log-stash from CSV files.

thanks.

2

Hi,

You cannot create visualizations on two index patterns right now in Kibana except for time series. Am not sure if that satisfies your requirement.

This is also more of a data modeling question. You cannot really enrich the 1st index in Kibana. You might be able to create scripted fields: https://www.elastic.co/guide/en/kibana/current/scripted-fields.html But we still have the problem of a single index.

@LeeDr can I get some help on this?

Thanks,
Bhavya

3

You might be able to enrich the 1st index using data from another index. I would start by reviewing this doc;

https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update-by-query.html

4

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