I am beginner to kibana, using it for a month now. I have one doubt related to index created in ES for plotting data. The question is if I have 3 dataframes, I want columns from each dataframe in dashboard. I can join 3 using primary key foreign key relationship. Whether I should join all 3 and write one index to ES and use it in kibana Or I have to maintain 3 Index.
Dashboard requirement is I want to show unique columns in dashboard if I join I may get duplicates but when I show average it will be correct but If I have to show columns only (I am using search object as of now) I am getting repeated rows.
Thanks & Regards