Filters Criteria

Parent Previous Next

 Filters Criteria

 

In the Filters Criteria screen, the user will have the ability to build filters based on selected Columns.  The Report Columns that the user choose on the previous menu will be visible in the Filters Criteria screen.

 

To start, drag & drop the report column you wish to enable a filter to.

 

 

Once there is a column to add a filter to, specific options for that column will be displayed in the filter field.

 

 

 

Normal

By default, the add type is normal. Click on the  icon to modify Item, Value1 and Value2 and to enter a formula by dragging and dropping Report Columns, Report Filters or Available Columns.

 

 

Click on the  icon to choose values for Value1 and Value2.

 

Note: Value2 is enabled when the operator is 'Between'.

 

Click the 'Add Row' icon to add another filter condition. Filter logic with 'AND' condition which is displayed by default.

 

Free Text

Add conditions in the text box provided. Click the  icon to enter formula by dragging and dropping Report Columns, Report Filters or Available Columns.


 

Once the filters are built correctly for the Report, click the  'Next' icon to proceed to the filters section.  To continue with this tutorial, click here