How to search through two different index patterns with common field?

I am trying to get metric data from two different index pattern that have a common field. Suppose that I have
Index A: with fields a , b, c
Index B: with fields c, d, e
what I want to do is to get the sum of all records that have have the fields b,c,d,e. where c has to be the same in both indexes. Is this possible to do in the kibana canvas.

I know that the Sql Join function is not yet supported in the canvas, but is it possible to do this using Timelion?

Hello @emad101

You could reference index-a-*,index-b-* - I think you'd need to create a new index pattern depending upon which kibana tools you're using.

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