Analytics as aggregates is now available in Stream Analytics
Published date: July 17, 2019
Developers can now use aggregates such as SUM, COUNT, AVG, MIN and MAX directly with the OVER clause, without having to define a window. This enables users to easily express queries such as “Is the latest temperature greater than the maximum temperature reported in the last 24 hours?”. Refer to Stream Analytics query language documentation for additional details.