Data Filtering is the process of choosing a smaller part of a Data Set and using that subset for viewing or analysis.

Filtering may be used to:-

• Look at results for a particular period of time.
• Calculate results for particular groups of interest.
• Exclude erroneous or “bad” observations from an analysis.
• Train and validate statistical models.

Filtering requires a specific a rule or logic to identify the cases you want to included or excluded in the analysis. Data Filtering can also be referred to as Data “subsetting” or a Data “drill-down”.

Data Sorting is the process that involves rearranging the Data into some meaningful order to make it easier to understand, analyze or visualize.

When working with Data, sorting is a common method used for visualizing it in a form that makes it easier to comprehend the story the Data is telling.

Data Filtering and Sorting

The Data Filter Designer is a powerful tool to help with the design and application of Data Filters and Data Sorting on Data Columns.

Select the Data Columns to filter and / or sort from the drop-down lists.

Click the 'Execute' button to apply the Data Filters and view the filtered Data.