Filter Fields for Statistics Reports

The following fields are found in the various filter sections of Statistics reports. The instructions below are for how to use those fields.

Information on using the filters is found in Filtering Statistics Reports.

Information about each Statistics report, its filter and its format, is found in the Understanding Statistic Reports section.

You may have noticed numbers to the right of the labels for the following fields:

• Groups
• Locations
• Lists
• Device Templates
• Aliases

If the number is greater than zero, it means you can select values in those fields to use in filtering the results of the report. Sometimes, selecting or removing a value from one field will impact the size of the number for other fields (e.g., choosing a group may reduce the number of available locations).

Keep in mind the following when creating filter criteria:

• If you are working on a Lists report and the number of available Lists is zero, there will be no data to include in the report.
• If you are working on a Sensors report and the number of available Device Templates or Aliases is zero, there will be no data to include in the report.

Report Type

The Report Type field is found on all statistic report filters and determines what kind of report you are creating and what filter criteria can be applied to the report:

• For Lists, the Report Type field lookup includes all available list reports (the default is List Completion - Req).
• For Sensors, the Report Type field lookup includes all available sensor reports (the default is Sensor Readings).

You can only choose one value in this field. Once you choose a value, the filter section will refresh.

Date Range

A Date Range field is found on all Lists report filters and all Sensors report filters except Inactive Sensors, which only reports for today's date, by default. This field allows you to control what days of data to include in your report:

• The range can be a specific date, such as Today, Yesterday, or another date you select from the calendar.
• The range can be multiple days, weeks, or months, but not more than 90 days.
• A date range cannot end on a future date.

If your active workspace is a location, then the dates and times you see in reports will be based on the location's local time.

If your active workspace is a group, then the dates and times you see will be UTC. If your time zone is behind UTC, then there are times when group-level reports could display tomorrow's date (e.g., if you are working in EST after 7:00PM local time, the dates that display on group-level reports will display tomorrow's date because it would be after midnight, UTC).

The opposite occurs if your time zone is ahead of UTC. In those cases, it may be after midnight where you are located, but it is before midnight UTC, so group-level reports would display yesterday's date (e.g., if you are working in Paris at 12:30AM local time, the group-level reports would still have yesterday's date on them).

The reason this occurs is because (1) location-level reports take data from records that were recorded in one time zone -- the local time of the location -- so they can present it that way, while (2) group-level reports could have records from locations in multiple time zones, in which case, all reports are presented in UTC to create a unified picture of the data.

Standard Date Ranges

For the standard date range look up, you can choose from:

• Today (the default value for this field) starts at midnight on today's date and ends at the time the filter is applied to the report
• Yesterday is the full 24-hour period for yesterday's date
• Last 24 Hours is the 24-hour period before the filter is applied to the report 
• Trailing... ranges start at midnight on the number of days before today date and includes today up to the time the filter is applied to the report

Custom Date Ranges

For the Custom Date range, you enter a Start Date and an End Date using the calendar tool that pops up when you click in each field.

• The default values for the two fields are based on the standard date range that was selected before you chose Custom:
  • If Today was previously selected, the Start Date and End Date with be today's date.
  • If Yesterday was previously selected, the Start Date and End Date will be yesterday's date.
  • If Trailing 7 Days was selected, the End Date will be today's date and the Start Date will be 7 days before, inclusive.
  • If Trailing 30, 60, or 90 days was selected, the End Date will be today's date and the Start Date will be 30, 60, or 90 days before, inclusive.
• The Start Date has to be older than the End Date.
• The Start Date and End Date can be the same.
• You cannot choose a date in the future for either field.
• You are limited to blocks of 90 days:
  • If you choose a Start Date that is less than 90 days before today, you can pick any date after the Start Date as the End Date without having an impact on the selected Start Date.
  • If you choose a Start Date that is more than 90 days before today, the End Date will default to 90 days after the Start Date.
    • You can change the End Date to any date within that 90-day block without impacting the Start Date.
    • If you choose an End Date that is greater than 90 days after the Start Date, the Start Date will change to 90 days before the selected End Date.
  • If you choose an End Date that is before the Start Date, the Start Date will change to 90 days before the selected End Date.

Custom Date Range for Sensors - Daily Comparison Report

For the Sensor - Daily Comparisons report, the you first choose a Start Date and then the Date Range:

• • Previous 2 days runs the report for the Start Date you pick and the day before, including today if that is the Start Date you picked 
  • Previous 3 days runs the report for the Start Date you pick and the 2 days before, including today if that is the Start Date you picked
  • Previous 4 days runs the report for the Start Date you pick and the 3 days before, including today if that is the Start Date you picked
  • Previous 5 days runs the report for the Start Date you pick and the 4 days before, including today if that is the Start Date you picked
  • Previous 6 days runs the report for the Start Date you pick and the 5 days before, including today if that is the Start Date you picked
  • Previous 7 days runs the report for the Start Date you pick and the 6 days before, including today if that is the Start Date you picked

Groups

The Groups field is found on all statistics report filters and functions as follows:

• If your active workspace is a location, the Groups field is not applicable. Only data from the active location will be included in the report.
• If your active workspace is a group and child groups exist:
  • You can leave the field blank and include data from all locations of all child groups in the report.
  • You can select one or more groups and only include data from their locations in the report.

If the number next to the Groups field label is greater than 1, use the following procedure to select one or more groups to include in the filter; otherwise, leave the field blank to include all:

1. Click in the field to display the groups lookup, then click on one of the groups to add to the field.
   • If you click in the field again, you will see that the selected group is now highlighted on the lookup.
2. To add another group, repeat Step #1. Each group you pick will be added to the field and will be highlighted on the lookup.
3. To remove a group:
   • Click on the X next to the name.
   • Click on the highlighted name in the lookup.

Locations

The Locations field is found on all statistics report filters and functions as follows:

• If your active workspace is a location, then data from that location will be included in the report.
• If your active workspace is a group:
  • and you leave the Groups field blank:
    • The Locations lookup consists of all locations in the active group or its child groups.
    • If you leave the Locations field blank, then data from all locations of the active group or its child groups will be included in the report.
  • or you selected one or more groups in the Groups field:
    • The Locations lookup consists of all locations from those selected groups.
    • If you leave the Locations field blank, then data from all locations of the selected groups will be included in the report.

If the number next to the Locations field label is greater than 1, use the following procedure to select one or more locations in include in the filter; otherwise, leave the field blank to include all:

1. Click in the field to display the locations lookup, then click on one of the locations to add to the field.
   • If you click in the field again, you will see that the selected location is now highlighted on the lookup.
2. To add another location, repeat Step #1. Each location you pick will be added to the field and will be highlighted on the lookup.
3. To remove a location:
   1. • Click on the X next to the name.
      • Click on the highlighted name in the lookup.

Lists

The Lists field field is found on the following statistics report:

• List Completion - All
• Incomplete Lists
• Reusable Lists
• Anomalies

The Lists fields lookup functions as follows:

• If your active workspace is a location, the Lists lookup consists of all lists available to that location.
• If your active workspace is a group:
  • and you select one or more locations in the Locations field, the Lists lookup consists of all lists available to those selected locations.
  • or you select one or more groups in the Groups field but leave the Locations field blank, the Lists lookup consists of all lists available to all locations of the selected groups.
  • or you leave the Groups and Locations field blank, the Lists lookup consists of all lists available to all locations in the active group or its child groups.

The Lists field, itself, functions as follows:

• If you select one or more lists in the Lists field, the report results will only include data from the selected lists.
• If you leave the Lists field blank, the report results will include data from all lists on the lookup.

If the number next to the Lists field label is greater than 1, use the following procedure to select one or more lists to include in the filter; otherwise, leave the field blank to include all:

1. Click in the field to display the locations lookup, then click on one of the locations to add to the field.
   • If you click in the field again, you will see that the selected location is now highlighted on the lookup.
2. To add another location, repeat Step #1. Each location you pick will be added to the field and will be highlighted on the lookup.
3. To remove a location:
   • • Click on the X next to the name.
     • Click on the highlighted name in the lookup.

Device Templates and Aliases

The Device Templates and Aliases fields function together as follows:

• You can only populate the Device Templates or Aliases field in a report filter, you cannot populate both.
  • If you select one or more Device Templates and then select one Alias, the Device Template field will be cleared.
  • If you select one or more Aliases and then select one Device Template, the Alias field will be cleared.
• If your active workspace is a location:
  • The Device Templates lookup consists of those templates used by sensors at the location.
  • The Aliases lookup consists of those aliases used by active sensors at the location.
• If your active workspace is a group:
  • The Device Templates lookup consists of those templates used by sensors at all location of the group or its child groups.
  • The Aliases lookup consists of those aliases used by active sensors at all location of the group or its child groups.
• Selecting one or more Device Templates will only include data in the report from sensors that use that template.
• Selecting one or more Aliases will only include data in the report from sensors that use that alias.
• Leaving both the Device Templates and Aliases fields blank will include data in the report from all sensors.

If the number next to the Device Templates or Aliases field label is greater than 1, use the following procedure to select one or more to include in the filter; otherwise, leave the field blank to include all:

1. Click in the field to display the lookup, then click on one to add to the field.
   • If you click in the field again, you will see that the selected device template or alias is now highlighted on the lookup.
2. To add another, repeat Step #1. Each device template or alias you pick will be added to the field and will be highlighted on the lookup.
3. To remove a device template or alias:
   • • Click on the X next to the name.
     • Click on the highlighted name in the lookup.