It looks like you need to perform calculations across data. The best way to address this would be to get both fields into the same document. How are you ingesting your data?
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.