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.