Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, could you please help with what is the best way to write the formula for calculating skewness.
Following is the formula used to calculate the skew of s data set
=Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])
Skewness formula as follows:
=Skew(DISTINCT {<Inventory_Position = {‘OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Skew(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
skew(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
skew(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+
Skew(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])
Not entirely sure what you are needing, but may be this
=Skew(TOTAL Aggr(
Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])
, Inventory_Position))
Hi,
You can make your expressions a lot simpler if you write them like this:
Count(DISTINCT {<Inventory_Position = {"OOS","Low Stock","Intolerance","Overstock","NoDemand"}>} Week&Material&[Supplier Loc]&[Customer Loc])
And then calculate the skew over your aggregated counts.
SKEW (AGGR(Count(DISTINCT {<Inventory_Position = {"OOS","Low Stock","Intolerance","Overstock","NoDemand"}>} Week&Material&[Supplier Loc]&[Customer Loc]),Inventory_Position))
Not entirely sure what you are needing, but may be this
=Skew(TOTAL Aggr(
Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])
, Inventory_Position))
Hi Sunny,
Your formula actually worked. Thank you for the information.
I am trying to get average\ skewness of inventory_positions
I am trying to get average\ skewness of inventory_positions
It worked? and you still trying to get average\skewness? You mean you also need average? may be this
=Average(TOTAL Aggr(
Count(DISTINCT {<Inventory_Position = {'OOS'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Low Stock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Intolerance'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'Overstock'}>} Week&Material&[Supplier Loc]&[Customer Loc])
+Count(DISTINCT {<Inventory_Position = {'NoDemand'}>} Week&Material&[Supplier Loc]&[Customer Loc])
, Inventory_Position))
Thank you Sunny! it worked.
You marked your own response as correct ... did you want to mark one of my responses as correct?
Hi Sunny, you got that correct. i have close this skew thing today. then go home.
sorry if it was lots of work for you.