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:




      However, nested aggregation is not allowed.


      Anyone have a thought on another way of doing this?