Hello,
I have a set of stages I am logging. A GUID is on each record to tie the stage together.
Example:
Guid Stage
1 Stage 1
1 Stage 2
1 Stage 3
1 Stage 4
1 Stage 5
2 Stage 1
2 Stage 2
2 Stage 3
2 Stage 4
2 Stage 5
I am looking to put a visual together on any GUID which has any missing stages.
In SQL I would use something along the lines of:
select * from tbl as a
where stage = 1 and
not exists (
select * from tbl as b where
stage = 5 and a.guid = b.guid
)
Any advice on how to achieve this in elastic/kibana?