Hi,
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
event:{
volume: 140
volumePercentage: 140/810
},
event:{
volume: 320
volumePercentage: 320/810
}, event:{
volume: 350
volumePercentage: 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?