0

Standard deviation

I have a data source from an excel spreadsheet.  I have columns for order number, invoice date, and turn days (time it took us to complete the order).  I would like to get the standard deviation of the turn days for all of the orders invoiced in the last 60 days. I keep thinking I've got it figured out, but it's never right.  Can anyone provide some guidance please.  Thanks!

 

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Randy! 

    Thanks for the question. To accomplish this, I would implement a formula like this into your Klips:

    STDEV(SELECT(<turn days>,BETWEEN(<invoice date>,DATE_ADD(TODAY(),day,-60),TODAY())))

    Here's an example of how that would look in Klipfolio, where column D is turn days and A is invoice date:



    This will return the standard deviation of all turn days that meet the criteria of being in the last 60 days. 

    Hope this helps! If you have any further questions around this, feel free to log a ticket with our support team and we'll be happy to assist further! 


    Cheers,
    Parker

Please sign in to leave a comment.