Reconciliation between two index data in Kibana visualisation in realtime

I have a requirement to perform reconciliation / join between 2 indexes.
Say,
Person A ( index A ) has Cars AAA, BBB, CCC, DDD
Person B ( index B ) has Cars BBB, EEE

We wanted to build a widget ( pie chart / table ) in real time without pre computing to see below results:

  1. Person A - Total Cars ( 4 ), Have same cars of Person B ( 1- BBB ), Cars not with Person B ( 3 - AAA, CCC, DDD )
  2. Person B - Total Cars ( 2 ), Have same cars of Person A ( 1- BBB ), Cars not with Person A ( 1 - EEE )

Please let me know are there any means that Elasticsearch / Kibana supports to build above visualisation in real time without pre computing them.

Thank you!
Amar

Hmm, I think you might be able to do this in Elasticsearch with a bucket script aggregation. TSVB in Kibana has some support for bucket script aggregations, but I don't know if it can perform the index reconciliation you are asking for.

Thank you! TSVB is helping to an extent. But it's not fitting to the use case mentioned above.

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