Adding a Chart
Click the + button in one of the squares of the report you are configuring.
Select Add Chart from the list of options.
This will then open up the configuration window (see below).
Title
The first field asks you to enter in the Title.
This can either be done via this first field or by clicking into the 'Click to enter Plot Title' via the chart preview:
Chart Types
You are then able to select which sort of chart you wish to display your data. The options are as follows:
Axis Data
The next part of chart configuration asks you to determine the X and Y axis. Depending what type to chart you have selected above you will also have the option to add a secondary Y Axis (Line, Scatter, Area, Column, Stacked or Combo) or secondary X Axis (Bar). If you select a Pie Chart you will not have the option to add any secondary axis.
For the source of both the X Axis and Y Axis you will have any field in the following areas:
- General (e.g user name, week, month etc)
- Seasons, Phases, Fixtures (as created in Administration - Configuration - Seasons Phases Fixtures)
- Wellness (all wellness data)
- Medical (Injury, Illness and Treatment Notes)
- Data Capture (any test set up on you platform)
Click the drop down source type list and you can either scroll until you find the field you are after or you can type in the search box (see below). Once you have have source type selected you will need to then select the specific source.
Once you have your source selected you are able to choose the calculation type.
For most fields you will have the choice between none and count. For number fields you will have the option of the above along with minimum, maximum, sum and average.
Here is how each of those calculation options will show:
- None - This will simply display the value(s).
- Count - Number of occurrences.
- Minimum - Minimum number.
- Maximum - Maximum number.
- Average - Total/Count.
- Sum - Total
If you select minimum, maximum, average or sum have the option to select a Moving Range.
This moving range allows you to compare overall values vs a moving range for your pre-defined time frame. If you plot two Y-Axis of the same parameter make one with a moving range vs one without to compare overall results with your range.
Extended Chart Options
Click Extended Chart Options to display options on joining line charts and legend orientation.
Please note you can also manually move the legend by dragging it via the right hand preview screen to the desired position.
Filters
The next part of the configuration allows you to select who to data applies for (team, group and/or individual), the date range to select the data from (fixed or dynamic), whether you want to group the data, filter it and/or order it.
Select Users and Group:
In this section, by default, the users you selected when initially setting up the report will be chosen.
This is pre-populated for your convenience if creating a report for the same user(s), however you still have the ability to configure which user(s) you want to display data for in each chart.
Clicking into the field will show you the drop down. This will give you a list of All Team (Users, Average and Sum), Each Group (Users, Average and Sum) and each member.
If you select all team, a group or any member the data will display for each member you select.
If you select all team (average) or group (average), the data will display only the average of the group or team.
If you select team (sum) or group (sum), the data will display the total for the group or team.
Select Date Range:
Much like Users and Groups, in this section, by default, the date range you selected when initially setting up the report will be chosen.
This is pre-populated for your convenience to save you time. However, it can be configured per chart.
Filter By:
The chart may be filtered by any of the fields you are able to report on. For example you may wish to view the average sessions missed along with the total sessions missed for the team.
You are then able to filter the data to show you the average games missed and total games missed when the type of injury was a fracture.
Likewise, you can filter the data to only display the data from one member so, using the example above, the average and total games missed will apply to that one member.
The following options are available when filtering data:
- =
- field is equal to X
- !=
- field is not equal to X
- In
- multiple values can be selected. For example user name In Player X, Player Y and Player Z
- >
- field is greater than X
- <
- field is less than X
- >=
- field is greater than or equal to X
- <=
- field is less than or equal to X
Group By:
Like in normal reporting, you are able to group your results by another field(s).
For example you may wish to view all causes of injury then group then by the side or part of the body they affected.
Order By:
The last part of the chart configuration allows you to order the data alphabetically by any field in injury, illness, treatment notes and general.
Please note that ordering grouped data will overwrite any grouping you may have.
Comments
0 comments
Please sign in to leave a comment.