I'm working on a new cube and i need to create a measure : "Std Dev of Value"
Transformer just don't do that. How can i do this calculation using external rollup or something else please ?
Example of datas :
Month Country Value
201202 FRANCE 15
201202 USA 12
201203 BRAZIL 3
I would like to show for year 2012 : sqrt((15-10)²+(12-10)²+(3-10)²/3) = sqrt((25+4+49)/3) = sqrt(26)
Do you have an idea?
This topic has been locked.
3 replies Latest Post - 2012-06-05T15:28:35Z by yangling
Pinned topic Standard Deviation in PowerPlay Transformer
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-05T15:28:35Z at 2012-06-05T15:28:35Z by yangling
yangling 0600018QDQ38 PostsACCEPTED ANSWER
Re: Standard Deviation in PowerPlay Transformer2012-06-04T23:13:42Z in response to Damien63PowerPlay for Windows plots these lines at 1.5 standard deviations from the mean. An example can be found by looking at Great Outdoors.
Hope this online help helps:
Returns the standard deviation of selected data items.
You can use standard deviation to measure the deviation or dispersal of values from the mean. A low standard deviation indicates that most values are distributed close to the mean, and a high standard deviation indicates that values are more spread out from the mean.
If the average mark for an exam is 63, approximately sixty-eight percent of the scores fall within the one standard deviation and approximately ninety-five percent of scores fall within two standard deviations of the average value. So if the standard deviation is 5, approximately sixty-eight percent of the group scored between 58 (63-5) and 68 (63+5). Approximately ninety-five percent of the group scored between 53 63-(2*5) and 73 63-(2*5).
The following formula represents the standard deviation for a sample: √(∑(-∑())2
standard-deviation (Product Cost)
Returns the result: A value indicating the deviation between product costs and the average product cost.
Damien63 270005D2HQ2 Posts