Ok, I have a data set that includes a host of temperature values (captured over time every minute or so). I am displaying a table that includes the name of the sensor, the temperature value, and then the stdev of these measures over time.
Now, I want to display a count of the number of instances where stdev=0 - in essence, the number of devices always reporting the exact same temperature all the time.
I would have expect the following to work:
However, nested aggregation is not allowed.
Anyone have a thought on another way of doing this?
Only issue is that it throws a "bad field name thermal_temp_c_stdev_instance" error - which implies that thermal_temp_c_stdev_instance is not actually set. Is Sense expecting that thermal_temp_c_stdev_instance be declared explicitly as a field name prior?