How To: Advanced Filters

When you would like to filter the data displayed on a dashboard, used the advanced filter option within the dashboard builder. This will use RQL syntax to allow users to filter in more complicated ways than ever.

Examples:

Find all Scale Check-in:

eq(measurements.scale_session_status.string_value,Scale%20Check%2DIn)

Find the summary information for SportVu:

eq(measurements.sports_vu_period.number_value,0)

Find the summary information for StatSports:

eq(measurements.stat_sports_drill_title.string_value,Full%20Session)

Find the summary information for Polar Team Pro:

in(measurements.polar_team_pro_phase_name.string_value,(Whole%20Session,Whole%20session))

Find the summary information for Gymaware:

eq(measurements.gymaware_session_rep_statistics_row_type.string_value,Total)

Find the summary information for Catapult:

eq(period_number,0)

Find all summary information for Catapult after June 6th, 2016:

and(eq(period_number,0),gt(measured_date,string:2016-06-06))

Find all information that is before January 2nd 2017, midnight EST:

lt(measured_date_time,2017-01-02T00:00:00:00-0400)

Find all information that is after January 10th, 2017:

gt(measured_date,string:2017-01-10)

Find all information that is recorded at 10, 11, or 12 am:

in(measured_hour,(10,11,12))

Exclude all information on Janurary 10th, 11th and 12th, 2017:

out(measured_date,(string:2017-10-10,string:2017-10-11,string:2017-10-12))

Exclude all information where the Number Value is 0:

ne(number_value,0)

Comparison Functions

Single Value Comparisons

<function>(<field>,<value>)

Single Value Functions

Multiple Value Comparisons

<function>(<field>,(<value1>,<value2>,...))

Multiple Value Functions

Logic Functions

All comparisons must match

and(<comparison1>,<comparison2>,<comparison3>,...)

Fields Available

Measured Date/Time

Value

Measured Values

Related Fields

measurements.<expression_name>[.number_value|.string_value]

Catapult

Value Types

Date/Time

Date/Times must be formatted as the following to be picked up properly. If a Time is not include it will default to the current time, which will not be preferred most of the time.
 

All numbers must be either 4 digits for Year/Offset or 2 digits for Month, Day, Hour, and Minute.

Syntax: Year-Month-Day"T"Hour:Minute-Offset

2017-01-01T00:00-0400

Integer/Int

Integers are Numbers without a decimal portion.

ex: 500

Decimal/Float

Decimals are Numbers with a decimal portion.

ex: 10.92

String

Strings are any text that can be typed in. Any of the above Value Types can be interpreted as Strings when specified by the Field configs using Type Casters. All Strings must be encoded as detailed under Encoding a String.

ex: Good
ex: Scale%20Check%2DIn

Advanced Topics

Encoding a String

Replace Character with Encoded.

Type Casters

Type casters are used to force the interpretation of the value. In the case that a value looks like a Integer but the Field only accepts a String you must cast it with. The same applies with Date/Time values and things that look like Date/Times like a Date alone.

Timezones

All Date/Times will default to using Greenwich Mean Time which is 4 or 5 hours ahead of Eastern Standard Time. It is recommended to specify the timezone to make sure filters work properly.

https://www.timeanddate.com/time/change/usa/new-york?year=2016