0

Standard Deviation

Hi Team ,

 

How  to  calculate standard deviation  of  a  measure or  metric  considering  last 26  weeks ?

 

Regards,

Ranga Naik 

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 6 yrs ago
    • Reported - view

    Hi Ranga,

    Create a set of the weeks you want to calculate the Standard Deviation of using Formulate model. This can be done in a number of ways, creating a dynamic set of weeks (that moves forward with time) or a static selection.

    Then create a calculated member using the Standard Deviation function:

    Hope that helps get you going.

    Ian 

    • BI Developer
    • vijay_patel
    • 6 yrs ago
    • Reported - view

    Hi, Ranga .

    Create calculated member.

    Use this Function in Script Editor and change according to your dimension name .

     >>>

    Stdev ( ( [Reporting Date].[Date].CURRENTMEMBER : [Reporting Date].[Date].CURRENTMEMBER.LAG(26) )
    , [Measures].[Sales] )

Login to reply

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 2Replies
  • 42Views
  • 3 Following