That means, the 2 first columns are the sum of price and quantity and the 3rd column divides both sums to get a ratio. Also I want this to be dynamic to changes in time range.
As far as I've seen getting the ratio is not possible in kibana, but I've noticed that there is a plugin were you can create Vega-Lite graphs in kibana.
I am new both in Vega-Lite and in kibana, so is there an example of code that creates a data table?
Visualizations within Kibana should respect whatever your time filter is all the time if that's what you mean. You can also keep your time filter to relative dates which will keep your time up-to-date if you're looking for something like a constant "last two weeks" window.
Any 3rd party plugins you pull-in to Kibana are free to do whatever they want though so no guarantees that they will continue to respect your time filters.
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.