Forum Discussion

M0n5ta09's avatar
M0n5ta09
Helper I
4 years ago
Solved

HELP - Standard Deviation

Hi everyone,   I've been trying for hours to calculate the Standard Deviation by month and by year based on _Faults per Day but getting nowhere. I'm expecting the STDEV to be around 0.75 for 2017 ...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    Can you try this measure:

    STDEV (LongTerm) = STDEV.S([_Faults per Day])
     

    Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

    Appreciate your Kudos !!!

    https://allure-analytics.com/

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

Can you try this measure:

STDEV (LongTerm) = STDEV.S([_Faults per Day])
 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

  • M0n5ta09's avatar
    M0n5ta09
    Helper I
    4 years ago

    Many thanks ALLUREAN.

     

    Once I got the values into a column in the table opposed to using a measure, it worked perfectly.