Forum Discussion
jmfillman
2 years agoHelper I
Help With Complex Standard Deviation
I have a table of data, like the below sample data and trying to write a measure from the parent table for Item ID. I need to calculate Standare Deviation based on the individual Plan ID, where S...
lbendlin
2 years agoSuper User
There is not enough data to make this statistically significant. How many rows are in your actual data?
jmfillman
2 years agoHelper I
This is just sample data. Each plan can have 1 to n rows and each Item ID can have 1 to n plans. Actual data is currently about 11,000 rows, but varies month-to-month. Ultimately, I need a value to indicate whether month-to-month hours are nearly the same, by plan, or have significant variability, where higher variability between months of the same Plan ID and for the Item ID is a good thing, where little or no variability is not good.