Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Removing outliers in a crosstab
Migrateduser
I have a crosstab with some data for which I calculated the count (# of observations) and the mean. Now I need to find the count and mean excluding outliers, which are defined as values more than two standard deviations away from the mean. In other words, I have columns: # obs, average, and standard deviation. (The aggregation is by hour, so the rows are hourly periods). I need to calculate two new columns: # obs adj and average adj, which will use only the values that fall within the 2-standard deviation range.
This is easy to do in a table by using filters. But I need to use a crosstab for this project, and the filtering in a crosstab works differently: I can only filter by measures in the data cube; I can't use calculated data fields.
Any ideas would be appreciated!
Find more posts tagged with
Comments
There are no comments yet