Get max of sum group by timestamp

I have Custom events sent with the following attributes:

  • a size which is a integer number
  • an id
  • timestamp

I group my event by interval of 5 minutes and sum all size:
SELECT sum(size) from Stat TIMESERIES 5 minutes
I would like to get only the maximum size. Is it possible ?
I tried max(sum(size)) but I get an error.

Unfortunately this is not currently supported. Please pop over to the post below and add your vote.


Thank you @stefan_garnham for your response. @briard Please do add your vote on this Feature Idea! Every vote counts :slight_smile:

1 Like