The question is how to calculate the overlap time range happened last month, the example one should be 3 min, but I need to calculate the whole month different meetings
You could do a max aggregation on the join time, a min aggregation on the leave time and compute the difference between those two values on client-side.
@jpountz Thank you for that, but I need to get the result for the whole long period (e.g. a week/month) instead of single meeting call. Do you have any good idea to address that?
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.