4 Replies Latest reply: May 14, 2015 3:08 PM by Chris Kelley RSS

    Counting the output from stdev

    Chris Kelley

      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:

       

      count(stdev(thermal_temp_c)=0)

       

      However, nested aggregation is not allowed.

       

      Anyone have a thought on another way of doing this?