How to remove the Outlier data from any visualization?

How to remove the Outlier data from any visualization?

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. 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

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