Define Filter Condition

Top  Previous  Next  

The Define Filter Conditions window allows you to define a filter condition as part of a data filter.

 

There are three types of filter condition you can define;

clip509

 

To define a simple fixed value condition select the column you want to apply the condition to, select the operator to use to compare the column, and finally select or enter the value to compare the column to.

clip510

 

To define a list of fixed values condition select the column you want to apply the condition to, select the operator to use to compare the column, press the list button, then repeatedly select or enter a value and press Add to add it to the list.

 

To remove a value from the list, select the value in the list and press Delete.

 

The list of fixed values condition is converted to a condition for each value in the list and grouped together.

clip511

 

A filter parameter condition filters the query data using a value set in a filter parameter set in a control panel.

 

To define a filter parameter condition select the column you want to apply the condition to, select the operator to use to compare the column, press the filter parameter button then select the filter parameter you want to use.

 

This video demonstrates creating and using a filter parameter.


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0