In this article, we will see how we can use different filtering conditions for different data types. There can be 3 basic types of data i.e. numeric, textual or date. We will see one by one the filtering conditions for each of these data types. Numeric data Let us consider the ‘sample travel data’ and
In this article you will learn about how to apply filters on numeric datatype using Helical Insight Adhoc Filter. Various filter conditions are : Equals (=) Not Equals (!=) Greater Than (>) Less Than (<) GreaterThan and Equal to (>=) Less Than and Equal to (<=) Between Not Between Is Null Is Not Null Is
Filters can be applied by using either of the 2 methods: Method 1: Double-clicking the icon Double click on Filter icon present in the columns on left panel. Method 2: Drag n drop column Select the ‘Filters’ tab and drag the columns that you want to apply as a filter into the selection area.
Different filters used on text data types. Equals: (=) Is one of Not equals (!=) Like Not like 1) Equals: (=) This is a filter term which is used in Adhoc to find text entries that are equal to a text specified by user. It used from auto mode. For equals we can use only
In this article, we will explain how to use filter by type operation. Filter by type button can be used to filter the type of files that the end user wants to see and, interact within the repository. This button is a drop down menu, clicking on which the user can see the 6 options