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
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
Could you share your workbook?
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!
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.