Gauge Filters Explained

Randall Berg -

Looking to limit the data in your gauge and not quite sure how to use the filters? You're not alone.  Hopefully this document should help clarify this important feature for you.

Filters change based on field type.  Currently we have date, text, number, and boolean fields.  

 

 

Date

When using date filters in a gauge, please keep in mind the date range for the dataset being used. (Ex. If using a "Lite" dataset, that only pull is data for the last 14 days, a "Previous Month" filter will not be accurate.

 

  • Equal To

Looks for values with the date and time you set.  You must set date AND time

  • Not Equal To

Looks for values that do NOT match the date and time you set.  You must set date AND time

  • Is Not NULL

Looks for rows of data with a value in this field.

  • Is NULL

Looks for rows of data without a value in this field.

  • Between

Looks for values between the dates selected, (dates only, no time), not including the last date entered. So if the filter is set to "Between" 01/01/2015-01/03/2015, then January 3 is not included.

  • Last (n) Hours

Looks for values within the last set number of hours, including the current hour as hour 0. So if the current time is 6pm, when n=2, the filter will include values from 6pm, 5pm, and 4pm. If you do not want to include the current hour as "0", simply check off the "Exclude Current Hour" option.

  • Last (n) Days

Looks for values within the last set number of days, including today as day 0. So if the current day is January 6th, when n=2, the filter will include values from January 6th, 5th, and 4th. If you do not want to include the current day as "0", simply check off the "Exclude Current Day" option.

  • Last (n) Weeks

Looks for values within the last set number of calendar weeks including the current week as 0.  So if it's currently Thursday, when n=1, the filter will include Monday through Thursday of the current week as well as Monday through Sunday of the previous calendar week. If you do not want to include the current week, simply check off the "Exclude Current Week" option.

  • Last (n) Months

Looks for values within the last set number of calendar Months, including the current month as 0.  So if the current date is December 15, when n=2, the filter will include values from December, November, and October. If you do not want to include the current month as "0", simply check off the "Exclude Current Month" option.

  • Last (n) Quarters

Looks for values within the last set number of calendar quarters, including the current quarter as 0. If you do not want to include the current quarter as "0", simply check off the "Exclude Current Quarter" option.

  • Last Weekday

Pulls data for the last weekday.  So if the filter is run on Monday, it pulls back data from Friday.

  • Earlier Than (n) Days Ago

Pulls back data where the date value is older than n days ago, so if today is December 15, 2015 and n=4, then it will show tickets starting on December 10, 2014.  Today is day 0, December 14 is 1, 13 is 2, 12, is 3, and 11 is 4.

  • Later Than Today

Shows data for values after today (does not include today)

  • Later Than

Shows data for values after midnight on a set date (does include that date)

  • Earlier Than Today

Shows data for all values earlier than today (does not include today)

  • Earlier Than

Shows data for all values earlier than a set date (does not include that date)

  • Next (n) Days

Shows data for a set number (n) of days later than today (does not include today)

  • Next (n) Months

Shows data for a set number (n) of months starting with the current month as 1. So if today is September 15, 2016 and n=2, then this will include data for September and October. 

  • Week To Date (Mon-Sun)

Shows data for dates starting for the current week spanning Monday to the current day of the week.   

  • Week To Date (Sun-Sat)

Shows data for dates starting for the current week spanning Sunday to the current day of the week.   

  • Weekdays Only

Typically used in combination with another date field, this filter shows data only for weekdays and excludes weekends.   

  • Month To Date

Shows data for dates starting from the first of the Month to the current day

  • Quarter To Date

Shows data for dates starting from the first of the Quarter to the current day

  • Current Week (Sun-Sat)

Shows data for dates starting for the current week spanning Sunday to Saturday.  This can show dates in the future.

  • Current Week (Mon-Sun)

Shows data for dates starting for the current week spanning Monday to Sunday.  This can show dates in the future.

  • Current Month

Shows data for dates starting for the current calendar Month.  This can show dates in the future.

  • Current Quarter

Shows data for dates starting for the current Quarter.  This can show dates in the future. (Please note that this refers to calendar quarters)

  • Previous Week (Sun-Sat)

Shows data for dates starting for the previous week spanning Sunday to Saturday.

  • Previous Week (Mon-Sun)

Shows data for dates starting for the previous week spanning Monday to Sunday.

  • Previous Month

Shows data for dates starting for the previous calendar Month.

  • Previous Quarter

Shows data for dates starting for the previous Quarter.

  • Previous Year

Shows data for dates starting for the previous Year.

  • Year to Date

Shows data for dates starting from the first of the current Year to the current day.

  • Current Year

Shows data for dates starting for the current Year.  This can show dates in the future.

  • Today

Shows data for values with a date the same as the current date.

  • Yesterday

Shows data for values with a date the day before the current date.

 

 

 

Text

Text filters have 2 options, standard and custom.  

Standard - Allows you to click and select which text based fields you'll like to select from.  This list by default shows the first 50 fields (alphabetically), but by searching you can see more.  Please note that if the value you're looking for is not currently in the dataset, then it will not show.  If you'd like to use a field not currently showing, then use the custom filters

Custom - Allows you to manually input values or use wildcards. Please note that all custom text based filters are case sensitive! Values must be typed in EXACTLY as they appear in the database. Below are the possible filter conditions that can be applies using the custom option.

 

  • Is Not NULL

Looks for rows of data with a value in this field.

  • in Is One Of

This filters selects rows when the field's value matches one value from the list.  It must EXACTLY match a value in the list.  The list is separated by pipes without spaces:

Larry|Steven|Brian|Eric|Randall

  • Is Not One Of

This filters does not select rows when the field's value matches one value from the list.  It must EXACTLY match a value in the list.  The list is separated by pipes without spaces:

Orlando|David|Christian

  • Is NULL

Looks for rows of data without a value in this field.

  • Is Like

This value pulls in rows when the field's value matches the desired term.  This supports a wildcard (%) but NOT lists.  If you filter for a board/queue called Service Desk , the following like filters would all work:

Service Desk

Service%

%ervice%   <-- in case you had multiple boards with service in the word and different capializations

  • Is Not Like

This value removes rows when the field's value matches the desired term.  This supports a wildcard (%) but NOT lists.

  • Matches Regex

This filter allows those familiar with the Regular Expression to use it to create filters.  

  

  

Number

  • Equal To

This filter will pull in data that exactly matches the desired value

  • Not Equal To

This filter will pull in data that does not exactly match the desired value.

  • Greater Than

This filter will pull in any data greater than the desired value

  • Greater Than or Equal To

This filter will pull in any data greater than the desired value or equal to the desired value

  • Is Not NULL

Looks for rows of data with a value in this field.

  • Less Than

This filter will pull in any data lesser than the desired value

  • Less Than or Equal To

This filter will pull in any data lesser than the desired value or equal to the desired value

  • in Is One Of

This filters selects rows when the field's value matches one value from the list. It must EXACTLY match a value in the list. The list is separated by pipes without spaces:

1|2|3|4|5|6

  • is Not One Of

This filters does not select rows when the field's value matches one value from the list.  It must EXACTLY match a value in the list.  The list is separated by pipes without spaces:

99|100|101|102

  • is NULL

Looks for rows of data without a value in this field.

 

  

 

Boolean

  • Is True

This shows data when the value in the field is True

  • Is False

This shows data when the value in the field is False

  • Is NULL

Looks for rows of data without a value in this field.

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk