Gauge Filters Explained

When pulling in your data, BrightGauge is as inclusive as possible. This means you may be required to filter down both at the dashboard level, report level, or with individual gauges, to only see the information pertinent to whoever you share a dashboard or report with. 

Depending on the dataset and datasource, the most common filters applied are:

  • Date - show for previous day, week, month, a range, etc
  • Board name
  • Client or Customer Name
  • Technician or Resource - member id, ticket owner, member name, resolved by, closed by, assigned to
  • Open or closed - closed flag, status, severity, urgency
  • Ticket type

 Start opening a gauge from a dashboard or select one from  "Gauges" menu in the top left corner.

Image_2019-12-03_at_1.36.43_PM.png

Once in the gauge builder, look at the dataset details on the top right. When unsure of what to filter for, the dataset details can show you a breakdown of the raw data behind each field. 

Image_2019-07-18_at_4.19.25_PM.png

 

Date Filter

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 pulls in data for the last 14 days, a "Previous Month" filter will not be accurate.)

 

DateFilter.png

 

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

 

Standard1.png

 
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 applied using the custom option.

 

TextCustom.png

 

Is Not NULL Looks for rows of data with a value in this field
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|Anthony|Eric|Randall
Is Not One Of This filter 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:

Anthony|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/or different first letter capitalization
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 

NumberFilter.png

 

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
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

BooleanFilter.png

 

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. 

 

Matches Regex

Image_2019-12-03_at_3.42.51_PM.png

This value pulls in rows when the field's value matches the desired term. You can input multiple terms separated by pipes without spaces. There are more advanced options available and we currently have it as a filter option for those familiar with the syntax. Something to note for those who are familiar, the "regex" conditions for our gauge filters only support PostreSQL regex functions. Furthermore, we currently use the "~" operator (which is case sensitive) hardcoded into the filter. 

Although, the feature is available in our gauge builder, we currently do not offer support for troubleshooting the RegEx syntax itself.

Was this article helpful?
8 out of 8 found this helpful

Comments

1 comment

  • Just what I needed to figure out the % wild card on the custom text filter. FYI to all that %mac is different than %Mac, but %ac will get them both.

    0