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?