In my use case
One index is sales history like:
BranchID ItemID Prices Sale_date PA1100 O18740 75 4/11/2018 PA6840 P25400 100 4/11/2018 .. .. .. ..
And the other is base line (documentation) like:
BranchID Region County Location Goal PA1100 North City A Street I,45 200000 PA2001 East City B Street J,87 155000 PA2045 East City C Street K,22 180000 .. .. .. .. ..
Both indices have more than ten thousands of documents.
So,How can I create a percentage visualizer by using sum of prices in sales history divided by sum of goal in base line.
Elastic Version : 6.2.4
Thanks for any help in advance.