I have a control chart with a parameter for standard deviations as well as several filters. I have a calculation for upper bound and one for lower bound, as well as one for outliers. I would like to have a visual that goes with this that would display the total number of records as well as the number of outliers. This number would update as the parameter or filters are changed. I feel that this has to be possible but not sure exactly how to go about it.
I do not currently have the data or a .twbx available to attach, but if I am not able to get an answer without sharing this, I will try to get that done.
Thanks in advance for the help.
You can put multiple sheets on the same dashboard. Do some of the values in one sheet, and other values in another sheet.
I have a feeling if this doesn't take care of your question, you're going to need a workbook to explain what you are looking for.