Can someone please guide me. I have each SKU and would like to get total count and standard deviation. I can get sum but for 7months of data how can I get total count and standard dev?
Break the standard deviation equation into its parts and solve them bit by bit:
Standard Deviation = Square Root of ( ( each X minus average X) / number of values ).
I prefer to break complex line item formulas into components ... each () is typically a separate line item and they get pulled together into a single simpler formula.
Average X = (sum of X / number of values)
Number of Values = sum of (If In relevant time range? then 1 else 0)
In relevant time range? = boolean time filter
Here is another thread that shows a more elegant way to achieve this in a single line item:
https://community.anaplan.com/t5/Best-Practices/STANDARD-DEVIATION
The link to the Anaplan Community provided returns a 404 error for me but Anaplan does have a Descriptive Statistics model that provides insight into how you can perform calculations such as finding the standard deviation. I'm attaching a screenshot for anyone else that stumbles onto this question but doesn't want to download the model
Cheers,
Marc
@mweinzim24
I get the same errror. Time for a new best practice I suppose.
To help answer @danishnoorani1 question and extend @hendersonmj answer, I posted this step-by-step DISCO method to calculate the standard deviation.
https://community.anaplan.com/t5/Anaplan-Platform/Standard-Deviation-Using-no-timescale-and-without-current-period/m-p/73141#M14752
In this method though I break one of the PLAN tenants. I have a back and forth calculation between the transaction module and the calculation module because the dimensions are the same. But it's pretty straight forward.
Hope it helps.
Thanks @JaredDolich !
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
