Adhoc Analysis Filter Conditions

By following this document user will know how to use Filter Conditions in Adhoc Analysis.

Prerequisites

For this example we are using Analysis Filter.pipeline dataset

Download dependency file from link given Link. After downloading the file, upload Analysis Filter.pipeline into the AIV dataset section.

Skill Level Required

No prior knowledge of Adhoc Analysis required but knowladge of binary filter conditions will be advantageous. Click here to know more about Adhoc Analysis in detail.

Use Filter Condition

Logging In

1. Log in to your AIV application using your valid credentials.

Creating a New Analysis

2. Navigate to the hamburger menu > Document > Adhoc Analysis, and click on the + icon to create a new analysis:

   

3. Upon clicking “Create Analysis”, the Analysis Selection dialog box will appear:

   

4. Fill in the details in the Analysis Selection window as shown:

   • Datasets: Analysis Filter
   • Rows: country
   • Columns: productLine
   • Values: quantityOrdered (Type: Count)
   • Filters: QuantityOrdered

IN Condition

The IN condition allows users to check if an expression matches any value in a list of selected values. This condition provides a multi-select dropdown, enabling the selection of multiple values.

1. Click on the settings icon at the Filters option:

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

NOT IN Condition

The NOT IN condition displays values that do not match the selected values, working opposite to the IN condition.

1. Go to the settings icon at the Filters option as in step 5 and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

• Results will be returned except for the selected values.

NULL Condition

The NULL condition displays columns that contain null values or when a value is missing or unknown.

1. Go to the settings icon at the Filters option as in step 5 and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

• Here there is no null value in the selected column, so it returns no result.

NOT NULL Condition

The NOT NULL condition returns column data that is not null, ensuring all fields in that column contain a value.

1. Go to the settings icon at the Filters option as in step 5 and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

Greater Than Condition

The Greater Than condition is used to see values greater than the entered value. Users will have a blank text box to manually enter the required value.

1. Go to the settings icon at the Filters option and enter the filter values:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

• Data displayed is greater than the applied condition value.

Less Than Condition

The Less Than condition is used to see values less than the entered value. Users will have a blank text box to manually enter the required value.

1. Go to the settings icon at the Filters option and enter the filter values:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

• Data displayed is less than the applied condition value.

LIKE Condition

The LIKE condition allows you to match a string to a value. It checks whether a string contains a specified value.

1. Delete the previous column from filters by clicking on the delete icon and add the country column in Filters:

   

2. Select the condition and fill in the details:

   

3. Click on the ✓ icon and then the PREVIEW button.

4. Upon clicking the CANCEL button, the window will look as follows:

   

NOT LIKE Condition

The NOT LIKE condition works opposite to the LIKE condition, filtering out the selected value and showing remaining values.

1. Go to the settings icon at the Filters option, select the NOT LIKE condition, and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

• Data for Australia will be filtered out as per the selected condition.

Equal To Condition

The Equal To filter is used to find exact matches. This filter provides only a list box instead of a multi-select. For multiple values, use the IN condition.

1. Go to the settings icon at the Filters option and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

NOT Equal To Condition

The NOT Equal To filter works opposite to the Equal To filter, excluding the condition and value applied and displaying the remaining values. It provides only a list box instead of a multi-select. For multiple values, use the NOT IN condition.

1. Go to the settings icon at the Filters option and fill in the details:

   

2. Click on the ✓ icon and then the PREVIEW button.

3. Upon clicking the CANCEL button, the window will look as follows:

   

Greater Than or Equal To Condition

The Greater Than or Equal To condition works like the Greater Than condition, with the addition that it includes the selected value.

Less Than or Equal To Condition

The Less Than or Equal To condition works like the Less Than condition, with the addition that it includes the selected value.