we have a index pattern with few indices with two different mapping, few fields are present in both mapping.
we want bucket the common fields from both mapping indices and want to perform metric aggs on data from both mapping indices to be in same visualization.
How to query different mapping index simultaneously to group fields on bucket level?
Index Pattern = customer_entity*
Indices= customer_entity_sales, customer_entity_visit
Sample: Index => "customer_entity_sales" Customer Code VolumeOfSale GrossSale XYZABC 123456789 10,929 70,121.3 Index => "customer_entity_visit" Customer Code LastVisitDate DayOfWeek XYZABC 123456789 Aug 3, 2020 @ 00:00 2
table vizualization for index pattern "customer_entity*"
Customer Code VolumeOfSale GrossSale LastVisitDate DayOfWeek XYZABC 123456789 10,929 70,121.3 Aug 3, 2020 @ 00:00 2
Kindly let us know how to achieve this?