I’ve a use case where groupBy query is done to return a metric called as ‘volume’. Now we want to calculate the percentage = Volume /TotalVolume. TotalVolume here is the total of all the volumes without groupBy in consideration/much like timeSeriesQuery.
Example: Here volume is the metric and percentage is calculated as postAggregator
TotalVolume = 140+320+350 = 810
I cant find a way to do it in single groupBy query. So I first did a timeseries query to get the totalVolume and then pass the totalVolume to a postAggregator in groupByQuery.
Is there any simple way to do the same?