How to remove the Outlier data from any visualization?
Article ID: KB0081671
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All versions |
Description
In some of the dataset, there are certain values which are skewed due to which the visualization might not look good or shall be inconsistent at times. It might be a possibility that the skewed values in the column shall be erroneous values too. To have an accurate visualization it is necessary to remove/not include those incorrect/skewed values from the visualization which is the outlier data.
Issue/Introduction
Removing Outlier data from visualization.
Environment
All Supported Operating Systems
Resolution
The erroneous/incorrect values can be excluded from the visualization using "Limit data using expression" option.
You can exclude the outlier data for a visualization using expression where you can limit the data for that particular column using any of the Spotfire functions.
For example if you need to include only the column values less than 90 percentile of the over all column values, you need to use the below expression:
[ColumnName] < P90([ColumnName])
You can decide upto what extent you need to limit the data in the visualization depending on your data and use any of the functions accordingly, you can refer the below documentation for details on functions to be used you can refer the below documentation:
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_statistical_functions.htm
To limit data using expression you can follow the steps below in the Spotfire Analyst:
Right click in Visualization area -> select Properties -> Data -> Click on Edit button under "Limit data using expression" where you can write this expression which shall limit the data for this visualization depending on the expression.
You can find more information on "Limiting data using expression" from the documentation below:
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_details_on_limit_data_using_expression.htm
You can exclude the outlier data for a visualization using expression where you can limit the data for that particular column using any of the Spotfire functions.
For example if you need to include only the column values less than 90 percentile of the over all column values, you need to use the below expression:
[ColumnName] < P90([ColumnName])
You can decide upto what extent you need to limit the data in the visualization depending on your data and use any of the functions accordingly, you can refer the below documentation for details on functions to be used you can refer the below documentation:
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_statistical_functions.htm
To limit data using expression you can follow the steps below in the Spotfire Analyst:
Right click in Visualization area -> select Properties -> Data -> Click on Edit button under "Limit data using expression" where you can write this expression which shall limit the data for this visualization depending on the expression.
You can find more information on "Limiting data using expression" from the documentation below:
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_details_on_limit_data_using_expression.htm
Additional Information
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_statistical_functions.htm
https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_details_on_limit_data_using_expression.htm
Feedback
Yes
No
Powered by
