Get only one fileld that is common accoss different indices, like SQL join on tables

Hello All,

Can someone please let me know I have a requirement to make dashboard which shows which usecases/ index are critical to be shown with status Heathy in green color and Red Critical.
Below is image I have achieved.
Now I want to know a way how can I collect this common field "usecases.status","usecases.category" that is present in all index and send to another self made index, so that using common index only I can show which usecases are critical or healthy using TABLE VISUAL. I always want to show top hit values of field.
With this I also see data duplication issue in seperate index, but as join don't work...I dont know better way to implement and avoid data duplication.

image

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