NetResults Tracker Help
Metrics

The Metrics operation is a way to gather and display statistical information based on your Tracker data. The information can be displayed as different chart types (bar, line, pie and others) using system defined Chart Layouts to specify the format for the chart. You can limit the records included in the statistical calculations (Input Records) by specifying a Saved Query. Only those records which match the Saved Query will be used when performing the statistical calculations. Chart parameters can be stored away for future runs as Saved Charts (for global, group, or personal use).

Topics Covered in This Section

Running a Chart

A chart can be generated using the "Project Status (Default) [Users]" Saved Chart or any other saved chart that has been added by a Tracker user with the appropriate privilege(s) by performing the following steps:

  1. Select a chart from the Saved Chart pulldown field.
  2. The options displayed in the Chart Layout, Input Records, and Chart Title fields will be automatically filled with the settings in the Saved Chart selected. If desired, make other selections for the Chart Layout, Input Records, and Chart Title fields.
  3. Click on the Show Chart button to display the chart.
  4. The chart will be displayed.

    If a chart has more than 20 data points, a scroll bar is available at the bottom to change what data is being as shown in the scroll bar sample. By default, the last 20 data points will be displayed. Drag the scroller to increase or decrease the amount of data being displayed. Or, use the options to the right of the scroll bar to jump to different data sets. The options available are "First", "Previous", "All", "Next" and "Last".

    If a legend is displayed, you can click on a legend item to exclude it from the chart data. Click on the excluded item again to restore it.

  5. To change the parameters used to display the chart, click on the Change Parameters button to return to the Chart Selection page.

Return to Topics List


Printing a Chart

After generating a chart, you can click on the Print link in the upper right corner of the page to print the chart.

Return to Topics List


Exporting Chart Data

After generating a chart, click on the Export link in the upper right corner of the page to export the chart data to a CSV (comma separated values) file. You can then open this file with another tool such as Microsoft Excel.

To create a chart in Microsoft Excel from the exported data, "rubber band" (left-click mouse and drag a rectangle around) the data plus column and row titles (exclude rows 1 through 3, but include the individual row/column titles in row 4 and column A along with the data in your selection) and click the Chart Wizard icon (or select Insert->Chart...). Click the Finish button in the Chart Wizard to accept the Microsoft Excel default settings for the chart; or make selections, click on the Next button, then click Finish to create a chart with custom settings. Please review the Microsoft Excel Help for further information on Excel charts.

Return to Topics List


Set a Default for the Metrics Page

You can set a default such that whenever you click on the Metrics icon a particular Saved Chart, Chart Layout, Input Records, and Chart Title will be ready to be displayed by clicking on the "Show Chart" button. By setting a default, you will be one click away from seeing your default chart when you go to the Metrics page. This is useful if there is a particular chart you will be displaying on a frequent basis.

To set a default for the Metrics page:

  1. Select a Saved Chart, Chart Layout, Input Records, and Chart Title to be used to generate your default chart
  2. Click on the Set as Default button at the top of the page

Return to Topics List


Save

The "Save" operation allows you to change the saved chart layout, input records, or chart title associated with a saved chart. You must have the appropriate privilege to perform this operation on a group saved chart. To make changes to a saved chart on the Metrics main page:

  1. Click on the Metrics icon in the Button bar
  2. In the Saved Chart pulldown, select the saved chart you wish to modify
  3. In the fields for Chart Layout, Input Records, and Chart Title make the desired changes
  4. Click on the Save button

Return to Topics List

Save as New

The "Save as New" operation allows you to save a new chart based on the settings displayed on the "Select a Saved Chart" page or when previewing a saved chart. On the "Select a Saved Chart" page, this operation allows you to create a new saved chart with different selections for Chart Layout, Input Records, and Chart Title.

To use the "Save as New" operation on the "Select a Saved Chart" page:

  1. Click on the Metrics icon in the Button bar
  2. Make selections for the Saved Chart, Chart Layout, Input Records, and Chart Title
  3. Click on the Save as New button
  4. Enter a name for the new saved chart, then select whether the saved chart will be a group or personal saved chart. If you select "Group" for the Saved Chart Type field, select the group that should have access to this saved chart in the Group field.
  5. Click OK to complete the operation

To use the "Save as New" operation after previewing a saved chart, review the instructions in the preview section.

Return to Topics List

Restrictions Related to Saved Group Charts

Depending on the user group privileges that have been assigned to your by your Tracker Administrator, you may only be able to use certain operations on certain saved charts for groups. For example, if you are a member of 2 user groups, but only have privileges to edit group saved charts for one of those user groups, some of the operations (e.g. "Add", "Edit") may be disabled when selecting a saved chart for a group where you have limited privileges.

Return to Topics List


Adding a Saved Chart

To create a saved chart, perform the following steps:

  1. Click on the Metrics icon in the Button bar
  2. If desired, select a saved chart in the Saved Chart pulldown to be used as a starting point for the new chart, then click on the Add button to the right of the "Saved Chart" pulldown

  3. Enter a name for your Saved Chart in the Saved Chart Name field
  4. In the Saved Chart Type field, select whether this chart will be a personal or group saved chart. Selecting "Group" indicates that any member of the user group selected in the "Group" field below will be able to access this saved chart.
  5. If "Group" is selected in the field Saved Chart Type above, select which user group will be able to access this saved chart in the Group field. You will only be able to select from user groups in which you are a member (However, the Tracker Administrator can add saved charts for all user groups). If a user group is not available for selection, you may not be a member of the user group or you may not have sufficient privileges to add a chart for a user group. If you are a member of the user group or are logged in as a user with the Admin privilege, the user group may not have visibility to at least one Project and Form. Only user groups that have visibility to at least one Project and Form (configured in the Admin section) will be available for selection when creating group saved charts.
  6. Click Next to continue

  7. Select the criteria for the Saved Chart. Click here for full details of the criteria selections for a saved chart.
  8. Click on the Add button

Return to Topics List

Editing a Saved Chart

A saved chart can be edited using the steps below. Some examples of changes you can make are:

Change the Name of the Chart
To change the name of a chart, use the steps below and change the Saved Chart Name property.

Display the Chart with a Different Layout
To change the type of chart displayed (e.g. whether it is a pie, bar, table or other layout), use the steps below to change the Default Chart Layout.

Use a Saved Query to Limit the Data Included in the Chart Results
To change what data is included in the chart, use the steps below to change the Input Records option.

Show Longer Labels
If some labels are being truncated due to long option menu item names, use the steps below to change the Max Label Length property.

Change What's Being Calculated
To change the calculation and breakdown items, use the steps below to change the Calculate the ..., Perform calculations ... and Breakdown calculations ... options.

To edit a saved chart, perform the following steps:

  1. Click on the Metrics icon in the Button bar
  2. Select a saved chart in the Saved Chart pulldown
  3. Click on the Edit button to the right of the Saved Chart pulldown
  4. Make changes to the criteria of the saved chart
  5. Click OK to save the changes

Return to Topics List

Deleting a Saved Chart

To delete a saved chart, perform the following steps:

  1. Click on the Metrics icon in the Button bar
  2. Select a saved chart in the Saved Chart pulldown
  3. Click on the Delete button to the right of the Saved Chart pulldown
  4. Click OK to confirm the operation

Return to Topics List

Previewing a Saved Chart

The preview operation allows you to make changes to the criteria of a saved chart before using the "Show Chart" operation to display the chart. This operation is useful when you want to display a chart with a change in the criteria for a saved chart, but want to preserve the saved chart's original settings. This is also useful for creating a new saved chart based on the criteria of an existing saved chart.

To preview a saved chart, perform the following steps:

  1. Click on the Metrics icon in the Button bar
  2. Select a saved chart in the Saved Chart pulldown
  3. Click on the Preview button to the right of the Saved Chart pulldown
  4. If desired, make changes to the criteria
  5. Click Save to save your changes. To create a new saved chart with the criteria displayed, click on the Save as New button. Otherwise, click on the Show Chart button to display the chart.
  6. If you clicked on the Save as New button, you will be prompted to select a name, chart type, and group for the new saved chart.

Return to Topics List

Standard Saved Chart within Tracker

Within Tracker, the chart Project Status (Default) [Users] is installed by default. The description below is how the chart is configured by default, but your Tracker Administrator or another user with the appropriate privileges may have changed the chart's settings. This chart cannot be deleted.

Project Status (Default) [Users]: A saved chart that will generate a pie chart, which displays the relative number of records in each possible state for the project, form and workflow created by default in the workgroup.

Return to Topics List


Saved Chart Criteria

Each saved chart has criteria which defines the data and formats that will be displayed when the chart is generated.

Chart Criteria Sections

General Options

Saved Chart Name
The name of the chart can be changed. The name of the system defined chart called "Project Status (Default) [Users]" cannot be changed. This option is not displayed for that chart.

Default Chart Layout
The chart layout determines the look and feel of the chart (e.g. whether it is displayed as a pie chart, table or other format). Select a saved chart layout to be used with this saved chart. Samples are available in the Chart Layouts section.

Project
This field is only available if you have been given visibility to more than 1 project in Tracker. You can limit the metric criteria to only those records that belong to a particular project(s) or * to match any project. The selection made in this field will determine the options available in the Form field. To select multiple projects, hold down the Ctrl button on your keyboard while clicking on the projects to select them.

Form
This field is only available if you have been given visibility to more than 1 form in Tracker. You must limit the metric criteria to only those records that were submitted using a particular form. However, depending on how your Tracker Administrator has configured the system, you may be able to select multiple forms or * to match any form. The selection made in this field determines which fields are available for selecting metric criteria. To select multiple forms, hold down the Ctrl button on your keyboard while clicking on the desired forms to select them. If you have selected one or more forms, a Get Fields button will be displayed. Click on the Get Fields button to refresh the metrics criteria page with the fields that belong to the forms you have selected. Only the fields and workflow states that are common to all of the forms selected will be available in the chart options.

Default Input Records
This option determines which records will be included when performing the calculations to generate the chart. Select "<All Records>" to include all records in the database or choose a Saved Query to limit the records included in calculations. The filtering which is done by selecting a Saved Query is done based on the records as they are now (at the time you display the saved chart) with the following exceptions.

Default Chart Title
Enter a title to be displayed at the top of the chart.

Max Label Length
A label in the chart is generated from the records included in the chart data. Enter the maximum number of characters allowed for a label in the chart (up to 50 characters can be displayed).

Chart Height
Enter the height in pixels that should be used to display the chart. This option is not applicable to the Table layout. We recommend using the default of "400" so that the chart area is visible within the bounds of a user's screen when the browser window is maximized. Using a setting like "600" or "800" will cause most users to have to use a browser's scroll bars to see the full chart area.

Decimal Places
Enter an integer from 0 to 7 as the number of decimal places that should be included in the chart when a table layout is used to display Float field data. This option is not applicable to layouts other than "Table".

Return to Criteria Sections List

Calculate the ... (y-axis for a line chart)

Select a calculation to be done on the set of records you chose in "Default Input Records". If you selected a Chart Layout to produce a line chart, the selection made in this section will become the y-axis when the chart is displayed.

Number of Input Records
Selecting this option indicates that the number of records included in the chart data will match the number of input records determined selection in the "Default Input Records" field.
Example 1: If you select this option and "<All Records>" is selected for "Default Input Records", the chart data will include all records in the database.
Example 2: If you select this option and a saved query is selected for "Default Input Records", the chart data will display all records in the database that match the criteria in the saved query selected.

Calculated Value of an Integer or Float field
Selecting this option indicates that a calculation (average, total, minimum, maximum) should be performed on the values of an Integer or Float field present in the set of records selected in "Default Input Records". Example: If you select this option and "average" value of "Estimated Size" field, then the chart will calculate the average value of the Float field called Estimated Size within the set of records selected for "Default Input Records".

Calculated Time Between 2 Date Fields in a Particular Date Increment
This option allows you to calculate a time (average, total, minimum, maximum) between the values of 2 date fields in a set of records. Selecting "<Now>" for the second date field indicates the calculation of time will be between the first date field and the current date and time. Example: If you select this option and "average" value from "Date Reported" to "Fix Date" in "days", then the chart will calculate the average time in days between the date fields selected for the set of records listed in "Default Input Records".

Calculated Time for Record to Progress From One State to Another
This option allows you to calculate a time (average, total, minimum, maximum) over a set of records between the time each record was in a particular state (state 1) to the time when the record was in another state (state 2). This calculation uses the Record History to compare the date a record was in state 1 to the date a record was in state 2. The calculation will be the same if a record moved directly from state 1 to state 2 or passed through other states before moving to state 2.
Example: If you select this option and "average" value from "Reported" to "Closed" in "days", then the chart will calculate the average time in days it took a record to go from the Reported state to the Closed state.

Number of Records Added
Selecting this option indicates that the number of records included in the chart data will match the number of records created in the set of records listed in the "Default Input Records" field.

Number of Transitions to a State From Another State
This option allows you to calculate the total number of transitions that were made into a state (state 2) from another state (state 1). Both Edit and Task operations are counted as transitions. Selecting the option "<Any State>" for state 1 indicates that all transitions that moved a record from any state (including state 2) into state 2 will be included in the chart data. Selecting the option "<Any Other State>" for state 1 indicates that all transitions that moved a record from any state (except state 2) into state 2 will be included in the calculation. This calculation yields the total number of times a transition between two states occurred. The calculation will count each time the transition occurred even if it occurred on the same record multiple times.
Example: If you select "Scheduled" as state 2 and "Reported" as state 1, then the calculation will be the total number of times any record moved from the Reported state to the Scheduled state.

Number of Records Moved to a State Which Passed Through Another State
This option allows you to calculate the total number of records that moved to a state (state 2) which passed through another state (state 1). Both Edit and Task operations are included in this calculation. Selecting the option "<Any State>" for state 1 indicates that the calculation will count any record which has moved to state 2 (including from state 2 itself). Selecting a specific state for state 1 limits the calculation to records that passed through state 1 before reaching state 2. Unlike "number of transitions," this calculation will not include multiple "hits" for the same record. Even if the same record passed from state 1 to state 2 multiple times, it will only count the record once as it is counting number of records and not number of transitions. Also, if a record loops while in state 2, the record is assumed to have completed the move from state 1 to state 2, when it first moves into state 2. This calculation can take longer to display the results than other charts because a significant amount of history data can be involved.

Return to Criteria Sections List

Perform Calculations ... (x-axis for line chart)

Select an option to add a further constraint to the data that resulted from the option in the Calculate the ... (y-axis for line chart) option above.

For Every Option in a Field
Selecting this option will perform the calculation selected in the Calculate the ... (y-axis for line chart) option above for every option within the field selected.
Example 1: If you select this option and "Project" as the field, the chart will display a separate calculation for each project in your database.
Example 2: If you select this option and "Status" as the field, the chart will display a separate calculation for each state in your database.

For Every State in <State Group> or For Every Reported By or Assigned To in [User Group]
Selecting this option will perform the calculation selected in the Calculate the ... (y-axis for line chart) option above for every state included in the State Group selected or for every user (Reporter or Assignee) in the User Group selected. State Groups and User Groups are configured by your Tracker Administrator in the Admin section.
Example: If you select this option with "Reported By" and "[Developers]", the chart will display a separate calculation for each user in the Developers user group who was the reporter of a record that matched the criteria in the Calculate the ... (y-axis for line chart) section.

As of the Current Date and Time (single calculation):
This option indicates that the chart should perform the calculation selected in the Calculate the ... (y-axis for line chart) option above as of the current date and time.

As of the End of or During a Time Increment for the Previous X Time Increments
This option indicates that the chart should generate the calculation selected in the Calculate the ... (y-axis for line chart) option above as of the end of or during each time increment for the number of increments selected.
Example: If you select "as of the end of" each "day" for the previous "2" "weeks", the chart will generate 14 calculations (one value for the calculation as of the end of each day for the last 2 weeks).

Dates are displayed as two part dates (month & day), except that the first (left most) calculation and any calculation that begins a new year will include a three part date (month, day, and year). All date parts are displayed using 2 digit values (with leading zeros if necessary), including the year. The date format is based on the preferences selected by the user who clicked Show Chart. The time zone used for calculations (to determine midnight of a date) is the time zone specified in preferences section of the user who clicked Show Chart. If you select "during each week" or "during each month," each week or month will be displayed as two dates with a hyphen between the two (a date range).

When you select week or month, the calculation may include a partial week or month as the most recent value (month to date, week to date) so that it always includes information up to and including the current day. Selecting month will always give you a partial month for the most recent (right most) value, unless today is the last day of the month. When you select "during each month," the months will always begin on the first of the month. When you select "as of the end of" or "during" each week, for the previous N weeks, you will always get data for a full week in each calculation. However, if you select "as of the end of" or "during" each week for the previous N months or years, you may get a partial week value (so that the data includes exactly N months or exactly N years). To get data that always includes exactly one week for each data point, use N weeks (rather than N months or N years).

As of the End of or During a Time Increment for a Date Range
This option indicates that the chart should generate the calculation selected in the Calculate the ... (y-axis for line chart) option above as of the end of or during each time increment for the specified date range. If you do not enter a value for the end of the date range (second date), the chart will use the day on which the chart is run (it will use today as the value). The dates you enter can include a time component, if desired. You can either click on the calendar icon to select a date or you can manually enter a date in the appropriate format (e.g. "mm/dd/yyyy HH:MM:SS AM/PM" or the date & time format selected in the Preferences section.). Click on the day to select the date to be entered into the date field. Click < or > to move backward or forward one month or click << or >> to move backward or forward one year. Click Now to set the date field to be the current date and time. Click on Exclude Time if you want to exclude the time information from being saved in the date field. For a field where the time information has previously been excluded, click Set Time if you wish to include the current time information in the field. Click OK to choose the highlighted date to be entered into the date field. Date will be selected and calendar dismissed when a date is clicked when the time is excluded. Dates displayed in red are non-business days according to the Business Days option in the Preferences section. Click Cancel to dismiss calendar without saving changes.
Example: If you select "during" each "day" from "01/01/2018" to "01/05/2018", the chart will generate 5 calculations (one value for the calculation during each day in the date range specified).

Dates are displayed as two part dates (month & day), except that the first (left most) calculation and any calculation that begins a new year will include a three part date (month, day, and year). All date parts are displayed using 2 digit values (with leading zeros if necessary), including the year. The date format is based on the preferences selected by the user who clicked Show Chart. The time zone used for calculations (to determine midnight of a date) is the time zone specified in preferences section of the user who clicked Show Chart. If you select "during each week" or "during each month," each week or month will be displayed as two dates with a hyphen between the two (a date range).

When you select week or month, the calculations may include a partial week or month at the beginning and/or end, as necessary to fit within the date range. If you select "during each month," months are displayed from the first of the month to the end of the month, with the possible exception of the first and last months displayed. The first month may be a partial month if your date range does not begin on the first of the month. Your last month may be a partial month if your date range does not end on the last day of the month.

Return to Criteria Sections List

Breakdown Calculations by a Field

This option indicates that the calculations generated based on the selections made above should be broken down by a field. For each calculation, a value will be displayed for each option in the field selected. In addition, if the chart layout selected for the saved chart contains a legend, one legend entry will be present for each item in the field selected.
Example 1: If you select this option and select "Status", the chart will display a calculated value for each state in your database.
Example 2: If you select this option and select a pulldown called "Product", the chart will display a calculated value for each option menu item configured in the pulldown field.

Breakdown Calculations by Every State in a <State Group> or by Every User in a [User Group]
Selecting this option indicates that the calculations generated based on the selections made above should be broken down by each state included in the State Group selected or by each user (Reporter or Assignee) that is a member of the User Group selected. In addition, if the chart layout selected for the saved chart contains a legend, one legend entry will be present for each state or user (Reporter or Assignee) in the State Group / User Group selected.
Example: If you select this option and select "Assigned To" and "[QA]", the chart will display a calculated value for each user in the the QA user group who is the Assignee for the records that matched the chart criteria.

Do Not Breakdown Calculations
This option will not breakdown the calculations generated by the chart criteria in the y-axis and x-axis sections above.

Don't Chart Data for a Breakdown Value if its Data is All Zeros
Checking the box for this option indicates that when the calculations are broken down per the option selected above, a separate calculation should not appear on the chart if its value is zero (e.g. it is zero for any particular option menu item / state / user).
Example: If you select the option "Breakdown calculations by the pulldown field "Product", then check the box for the option "Don't chart data for a breakdown value if its data is all zeros", and the chart data has 0 records that matched the criteria for Product A, the chart will not display a calculation or legend entry for Product A.

Return to Criteria Sections List

Return to Topics List

Chart Layouts

A chart layout provides the formats used to display a saved chart.

Area

Clustered Bar

Clustered Column

Line

Pie or Donut

Stacked Bar

Stacked Column

Table

Return to Topics List




NetResults Tracker © 1997-2018 NetResults Corporation. All rights reserved.