
1. Re: Color The Data Outliers, using standard deviation calc.
Carl Slifer May 26, 2016 3:33 PM (in response to Rahul Upadhye)1 of 1 people found this helpfulHowdy Rahul,
Your calculation is correctly. You just need to edit the table calculation of your StdDev Outlier calc. Once you drag it to the shelf right click and choose compute using 'Order ID'. This will make a new calculation for each Order Date. You need to do this as it is being based on calculations that are table calcs and you have to identify their scope to be used in the formula.
You will get one value which is null because it is by itself so you may wish to account for that in your true/false calculation.
Cheers!
Carl Slifer

2. Re: Color The Data Outliers, using standard deviation calc.
Rahul Upadhye May 27, 2016 2:15 PM (in response to Carl Slifer)Hey Carl,
That's very nice of you to provide a quick fix...
I was surprised how it worked on the superstore dataset, somehow it did not work on my actual dataset.
I need to deep dive into my actual dataset to understand this TableCalc
Thanks,
Rahul