I am using the below query in the Stream Analytics.
SELECT
AVG(DeviceFields.Temperature) as average,
100 as maximum,
65 as target,System.Timestamp AS time
INTO pbioutput2
FROM iotcts2Input
Group BY DeviceId, HoppingWindow(second, 10 , 5)
I need to show the average Temperature of the device for the past 10 seconds in the Radial Guage with the target temperature which should not be crossed along with maximum temperature and minimum.
I am getting the dataset correctly in Power BI ( app.powerBi.com) , but it sums up all the averages in the dataset and show a huge value. Can you please help how to set this correctly and where am i going wrong.
