Question

You are analyzing IoT telemetry stored in a KQL database in a Fabric Eventhouse. Analysts need a time-based trend line showing the average temperature per 5-minute interval over the last 24 hours, rendered directly as a chart in the KQL Queryset. Which query produces both the correct aggregation and the visualization?

Accepted Answer

Telemetry | where Timestamp > ago(24h) | summarize avg(Temperature) by bin(Timestamp, 5m) | render timechart

Answer

Telemetry | where Timestamp > ago(24h) | summarize avg(Temperature) by Timestamp | render barchart

Answer

Telemetry | take 24h | project avg(Temperature), bin(Timestamp, 5m) | render columnchart

Answer

Telemetry | where Timestamp > ago(24h) | project avg(Temperature) by bin(Timestamp, 5m) | render timechart