Blog Post

Azure Data Explorer Blog
2 MIN READ

Time Weighted Average and Value in Azure Data Explorer

adieldar's avatar
adieldar
Icon for Microsoft rankMicrosoft
Sep 29, 2024
Azure Data Explorer (ADX) supports time series aggregation at scale, either by the summarize operator that keeps the aggregated data in tabular format or by the make-series operator that transforms i...
Published Sep 29, 2024
Version 1.0
ADX
Azure Data Explorer
Fabric Real-Time Analytics
interpolation
KQL
kusto
Time series
Time weighted average
SchulC43's avatar
SchulC43
Copper Contributor
Oct 11, 2024

Very good work! The TWA is a very important aggregation function. I tested time_weighted_avg2_fl() and think you could increase the performance by moving the "| where _ts between (stime.._etime)" to the "let tbl_ex =..." definition. With this change I was able to reduce the scanned data to a minimum. Also preventing cold data hints.