Filters

Filter is applied to the data before using it to populate a chart. It can be used to cleanse the data or focus more closely on the target data for analysis. It cannot be changed dynamically in real time.

Filters can be added when creating a chart. Click on Create Chart button on Charts tab. You will be directed to the Chart creation page.

To add a filter for a chart, just drag & drop a field from the field list to the box below the label Filters. Based on the type of field, you will immediately see a form guiding you with the details of the filter. Below are listed the different filters available for each type of field.

Once you fill in the details & press the Yes button, a dropdown for the field is added to the box. It shows the field name with a couple of options available in the dropdown.

If you want to edit the filter, you can select the Edit option from the dropdown. If you want to delete the filter, you can select the Delete option from the dropdown.

You can add multiple filters to a chart. The filters are combined using an AND condition.

Filters for Text fields

There are 3 types of filters for Text based fields

Exact match

• Equals - matches rows where the filter column equals your input string
• Does not Equal - matches rows where the filter column does not equal your input string
• Is one of - matches rows where the filter column is one of the comma-separated input strings that you have provided. Please note, you will need to add quotes around each string for this filter.
• Is not one of - matches rows where the filter column is not one of the comma-separated input strings that you have provided. Please note, you will need to add quotes around each string for this filter.

Approximate or Pattern match

• Begins with - matches rows where the filter column begins with your input string
• Ends with - matches rows where the filter column ends with your input string
• Contains - matches rows where the filter column contains your input string
• Does not contain - matches rows where the filter column does not contain your input string

Presence of value

• Null - matches rows where the filter column is null
• Not null - matches rows where the filter column is not null

Filters for Number fields

There are 3 types of filters for Number based fields

Exact match

• Equals - matches rows where the filter column equals your input
• Does not Equal - matches rows where the filter column does not equal your input
• Is one of - matches rows where the filter column is one of the comma-separated inputs that you have provided.
• Is not one of - matches rows where the filter column is not one of the comma-separated inputs that you have provided.

Comparison based filters

• Greater than - matches rows where the filter column is greater than your input
• Greater than or equal to - matches rows where the filter column is greater than or equal to your input
• Lesser than - matches rows where the filter column is lesser than your input
• Lesser than or equal to - matches rows where the filter column is lesser than or equal to your input

Presence of value

• Null - matches rows where the filter column is null
• Not null - matches rows where the filter column is not null

Filters for DateTime fields

There are 3 types of filters for Date based fields

Date based filters

The input for these filters must be a date of the format YYYY-MM-DD to be consistent across different types of databases. You can select a date from the date picker which appears on clicking the input text box.








• Equals - matches rows where the filter column equals your input date
• Before - matches rows where the filter column is before your input date
• After - matches rows where the filter column is after your input date

Number based filters

The input for these filters must be a number (N) entered by you.

• Last N years - matches rows where the filter column value is within the last N years
• Next N years - matches rows where the filter column value is within the next N years
• Last N quarters - matches rows where the filter column value is within the last N quarters
• Next N quarters - matches rows where the filter column value is within the next N quarters
• Last N months - matches rows where the filter column value is within the last N months
• Next N months - matches rows where the filter column value is within the next N months
• Last N weeks - matches rows where the filter column value is within the last N weeks
• Next N weeks - matches rows where the filter column value is within the next N weeks
• Last N days - matches rows where the filter column value is within the last N days
• Next N days - matches rows where the filter column value is within the next N days
• Last N hours - matches rows where the filter column value is within the last N hours
• Next N hours - matches rows where the filter column value is within the next N hours
• Last N minutes - matches rows where the filter column value is within the last N minutes
• Next N minutes - matches rows where the filter column value is within the next N minutes
• Last N seconds - matches rows where the filter column value is within the last N seconds
• Next N seconds - matches rows where the filter column value is within the next N seconds

Presence of value

• Null - matches rows where the filter column is null
• Not null - matches rows where the filter column is not null