7 Replies Latest reply on Jan 5, 2017 4:04 AM by Chris Geatch

# Count Outliers on Control Chart

Hi everybody!

I have a control chart and calculated the outliers on the sheet, but the problem is that I have to show this number outside the sheet and this I didn't get.

When I do that outside, the number is getting null. Someone with ideas?

Here is the thing:

• ###### 1. Re: Count Outliers on Control Chart

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

• ###### 2. Re: Count Outliers on Control Chart

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

Hi Jose,

Could you  share your workbook?

• ###### 4. Re: Count Outliers on Control Chart

Sure! Here we go

• ###### 5. Re: Count Outliers on Control Chart

Goodmorning Jose

Find my approach below and stored in attached workbook version 10.1

• ###### 6. Re: Count Outliers on Control Chart

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

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.