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.
Canvas is being created to solve problems like these. It allows you to build visualizations from SQL statements that allow you to perform joins. I would recommend you try it out for this problem set.
If canvas does not work for you then, only timelion and visual builder offer support for multiple indices. You could create an expression that looks something like this in timelion .es(index="sales_history",timefield="yourTimefield",metric=sum:price).divide(.es(index="base_line",timefield="yourTimefield",metric=sum:goal))
I mean chart on visualize can filter by click on themselves.
How can I link or combine the indices. That make me use data from two indices in one visualize.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.