8 Replies Latest reply on Apr 16, 2018 11:25 PM by Tushar More

    Standard Deviation Over time

    ken school

      Hi all,

       

      I am trying to compute the standard deviation over time on my data set. Please see below:

      ss1.JPG

       

      The primary use case is to detect surge in counts for the field. However, the results I got shows a single standard deviation across the time frame. I am using a calculated field with WINDOW_STDEVP(count([item]))

       

      Due to the sensitive of the data, I can't upload the workbook, but following is the sample data set:

       

      time, item

      01-Dec, test

      02-Dec, test1

      02-Dec, test

      02-Dec, test2

      03-Dec, test

      04-Dec, test1

       

      The expected output will be the moving standard deviation and to detect a surge in the count of item at each time frame and in turn, increase in the standard deviation

       

      thank you so much!

       

      cheers,

      Ken