Connect two documents

Elastic Stack Kibana
1

I have an Index with two types: ticket and status. In a document of the type ticket are fields like TTS_Status which can be 1 to 6. A status document only has two fields: STS_Number and STS_Term, which could look like this: {"STS_Number":1, "STS_Term":"New"}.

If I create a pie chart, I want to relpace the number from TTS_Status with the matching String in STS_Term, by joining them with STS_Number.

2

There is no way of doing that in Kibana other than flattening the documents and including the child one in the parent document. There is an open enhancement request here: https://github.com/elastic/kibana/issues/1084

3

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