
1. Re: Count Outliers on Control Chart
Norbert Maijoor Jan 3, 2017 6:20 AM (in response to José Toledo)Hi Jose,
Find my approach as reference below and stored in attached workbook version 9.3
a. Count Outlier: if [Value]>80 or [Value]<70 then [Number of Records] END
b. Colour Indicator: if [Value]>80 or [Value]<70 then "A" else "B" END

Count outlier.twbx 20.3 KB


2. Re: Count Outliers on Control Chart
José Toledo Jan 4, 2017 6:02 AM (in response to Norbert Maijoor)Norbert, thank you for your response!
Inspecting your workbook I've tried this for count outliers: IF SUM([Sales]) < [lcl] or SUM([Sales]) > [ucl] THEN [Number of Records] END
Where lcl is lower limit and ucl is upper limit
Note: my limits are calculated fields
But I'm still getting the null value outside the sheet.
I'll proceed trying

3. Re: Count Outliers on Control Chart
Norbert Maijoor Jan 4, 2017 12:08 PM (in response to José Toledo)Hi Jose,
Could you share your workbook?

4. Re: Count Outliers on Control Chart
José Toledo Jan 5, 2017 2:42 AM (in response to Norbert Maijoor)Sure! Here we go

box.twbx 1.2 MB


5. Re: Count Outliers on Control Chart
Norbert Maijoor Jan 5, 2017 2:54 AM (in response to José Toledo)
box (1).twbx 1.2 MB


6. Re: Count Outliers on Control Chart
José Toledo Jan 5, 2017 3:41 AM (in response to Norbert Maijoor)Morning Norbert!
I'm so glad you're being this helpful, but maybe you didn't get my point.
The fact is: In this sheet you worked, I can show the outliers count (16), right? But in other sheet I can't show this same number.
It's exactly the same way you did the first workbook you sent me, one sheet has the graph and other sheet has just the outliers count.
You think that is possible? I'm working days on it haha
Thank you a lot!

7. Re: Count Outliers on Control Chart
Chris Geatch Jan 5, 2017 4:04 AM (in response to José Toledo)I can't see any file attachments, for some reason, but I only have version 9.3, so wouldn't be able to look at Norbert's solution anyway. If your second worksheet is simply to show the number "16" in this case), could it be that your calculated fields are incorrect because you don't have the same levels of detail added.
If you're saying something an outlier is something like "80% of the largest value", when you have it grouped by date then that comes out as 6.004, but on your "16" worksheet, if you haven't got it grouped by date, and you're just displaying "Count of Outliers", then the contributing calculation will be looking at "80% of the overall total of sales", which will be much higher. You might just need to drag the date field to the Detail button. Sorry if you've already done that and I just can't see, but I thought I'd mention it, just in case.