The Report Builder is a bespoke reporting feature designed to allow users to report on a whole host of data collected in Sports Office. Custom reports are built from one or more components which can be individually configured to give Multi Disciplinary updates on players or teams.

The purpose of this article is to show Staff users how to build a custom report and what each of the building components can be used for. Examples of reports will be provided to demonstrate the features/capabilities.

For a Staff account to be able to access the Reports Hub and build a custom report, the account will need the following user roles:

· Analysis Access

· Analytics Access

Once in the Report Hub, you can create a Custom report from the link on the right hand side.

Firstly, you will see the Report Options. From here, you can decide the default settings for each component. Would you like to lock players and/or timeframes into every component or choose those options each time you run the report?

This gives the flexibility to have a report with multiple components reporting on different players and/or timeframes.
For example, you may want to look at one component for the whole season whilst another component for the last 4 weeks.

Would you like to select players.....

…for each report component – Select players on a per component basis, which is useful if you want components to show preselected players when viewing the report.

…when running the report (this can be overridden on the report component) – This allows you to select players on the fly for all components when running the report.

Would you like to select the timeframe....

…for each report component – Set a timeframe for each report component, the timeframe you select tells the system where it should be pulling data from.

…for the whole report (this can be overridden on the report component) – Allows you to select one timeframe for all components in the report.

…when running the report (this can be overridden on the report component) – Allows you to select a timeframe each time you run the custom report.

If you choose ‘When running the report’ for either option, you will be presented with a modal to choose those options each time you run the report.

There are also two additional options:

Show the player picker when viewing the report - Defaults to players in current team – Enabling this will provide you with a player card selector at the top of your report when running the custom report. This allows you to select a player’s image and view data specific to that player within the custom report (Screenshot below shows what this looks like when viewing the report).

Show Intro in Report Component Wizard – Enabling this option allows you to fix your players/timeframe selection for a specific component, the component will then only show those chosen players and look at the chosen timeframe, even if you select players/timeframe for the whole report.

Setting a timeframe

You can Choose one timeframe for the whole report, set the timeframe on a per component basis or specify the timeframe as and when you run the report. This section will explain how to use the timeframe fields.

When you are happy with the settings and you have added a Report Name you can click the green Save button.

Custom reports are made up of Report Components or widgets. This will allow you to add multiple charts types reporting on a host of information for whatever timeframe and athletes you wish to view.
​

To start building the custom report you need to add a component. Select Add New Component to do this.
​

When you add a new component, the component builder will open and you will be able to select your Chart Type, there are four categories of charts across the top:

Once you have selected your component, select Next to be taken to the next stage. The options/fields you see next will be relevant to the chart type that you selected, sometimes this can just require a title or it can involve several more steps. For example, for a Chart Component (e.g. grouped data chart) you will be presented with multiple tabs (metric, players, groupings, options). Moving forward we will focus on this example as it will give you insight into the main tools of a component and how to use these if you come across them in any other area of the system.

Selecting Grouped Data Chart:

In the screenshot below you can see the metric tree. This allows you to select any data you have added to the site that you wish to view in the report component. The metric tree is broken down into different metric modules, which you can expand upon selection. After selecting the metric module, you will be provided with sub-categories and metrics that you can select as your data source.

Also, you can select one metric or multiple metrics to view in a report component. This might be done to compare two or more metrics against each other and/or stack the metrics on top of one another to see a total score. However, in this example, we will focus on selecting one metric e.g. Session Duration

The metric tree is quite extensive so a quicker way to find what you are looking for is by using the Search field at the top to easily find the metric you are looking for!

Metric Tree: Session Duration selected

After selecting your metric/s you will move to the next tab named Datasets, this is where you can select players/teams, timeframes, and charting options for the report component.
​

Name - This allows you to change the metric name on the go, for example, here our metric is Session Duration; if we wanted this to show as 'session minutes' or 'session length' for example then we could enter that into the Name field and it would show on the chart when viewing the report.

Players/Teams - To begin selecting your players/teams you need to click the Select players… drop-down field, which will show you a full list of all the teams on your system. The below will explain the different options available to you and how these affect the data that is shown in the grouped data chart:

Timeframe - Choose a timeframe and how you would like to aggregate the data.

For Timeseries charts, you will also see an option to apply a Model.
Model options allow you to view data as a Percentage Difference, Percentage of the max value or Percentage Change.

Lastly, there is an option underneath both the Player and Timeframe picker to Lock your choices. This simply means that if you change your report settings on Run, these components will maintain these settings.
Use case - You may always want this to show the season average for 1 set of players but for the other components in the report, you may wish to choose different time frames when viewing.
​

Grouping is a way of manipulating how you display data on the charts similar to pivoting. For example you may select Session Duration > Sum > Players in a team. Without Grouping, this would just give you 1 data point for the total session duration of all players.

If you Group by players, you would now view Session Duration for each individual player on the X axis. If you add a second Grouping by Date or example, when you click on a player on the chart, you would see the dates of each session which is contributing to his/her overall Session Duration.

Depending on the chart type (you can’t group on Timeseries Charts), the next step allows you to specify how you want your data to be grouped/visualised in the chart.

The grouping options will vary depending on the metric, for example:

Metric = Injuries received > Grouping options = by body part, tissue type, mechanism etc.

Metric = Session duration > Grouping options = by session theme, surface type, team etc.

Group Aggregation - Using group aggregation you can decide if the data you view is going to be representative of the mean, minimum, maximum, latest score etc. e.g I want to see the average session duration for each player over the reported time period.

1st level grouping - Select the top level grouping from the available options based off the metric selected e.g.

Metric = Session duration > Level 1 grouping = Team

Further groupings - You can continue to add more groupings selecting further options from the list. This allows you to drill into a dataset when you run the report.

Example: Show me Session Duration Grouped by Team > Player > Date

The 1st Level shows session duration for each Team Selected > the 2nd level - Click into a team to see the Specific Players in that team > the 3rd level - click into a player to see the specific dates of the sessions contributing to that players sum.

Multi series grouping - You also have the ability to have 2 groupings on the same level using the multi-series group slider.

Example: Show the Session Duration that each player has amassed this season and in which team it was collected against for the U18 players.

Metric= Session duration > Level 1 grouping = Team

Select multi series grouping > Add 2nd level grouping = Player

This will result in the data being displayed by Team and Player at the same time rather than having to click into the chart.

You also have the option to order by value or by name and choose if the data will show in an ascending or descending direction.

Using a filter is a way of highlighting or ignoring certain datasets from your selected metric. This can be useful to help zone in on what you would like to see/know.
​Example: Show players who have played more than 100 minutes this week

You can have multiple filters on each grouping and choose whether you want to match all or any criteria in the filter.

​Example: Show Head and Hamstring Injuries received this season

In the above example notice how we are matching Any of the below criteria, so show me the number of Any Injuries which were to the Head or Hamstring.

You could be more specific with the All option. It has to match all the criteria below it.

Example: Show players who have received both Head and Hamstring Injuries this season.

Here you can give your report component a name/title e.g. U18s Current Players - Session Duration This Season So Far.

Depending on your report configuration, you may have the ability to specify the timeframe for this report component (review Setting a timeframe above). Here, you have the additional feature ‘Chart As’ that allows you to decide how your chart is presented e.g. bar, column, spline etc.
​

NOTE: If you have selected "…when running the report (this can be overridden on the report component)" you will not see the timeframe options because you have said you would like to choose this each time your run the report.

Below are descriptions for each advanced option:

Highlights - This allows you to add a specific colour to certain player if you wished to highlight them. Use Case - You may wish to highlight certain positional groups in certain colours or highlight players of high interest.

​Trend Lines and Zones - This allows you to add colours to results based on thresholds or add coloured zones to chart to highlight thresholds.
Use case - You may want to show a minimum standard result line for a certain testing metric or add background colours to result tables for certain thresholds to add RAG ratings.

​

Once you are happy, select Finish. Then select Save on the Custom Report to save the new component you have built.

Config steps = Chart type: Pie > Metric: Days Missed > Players: Players in Team > Groupings: 1st level grouping by Players & enable ‘Interaction’ toggle > Timeframe if needed: This Season so far (Frequency = Entire Date Range) > Finish

Game Time by Seasons

Config steps = Chart type: Grouped Data Chart > Metric: Total Game Time > Players: Players in Team > Grouping: 1st level grouping by Season, 2nd level grouping by Player, enable Multi Series Group > Timeframe if needed: I used Specific Date Range and set frequency as Season & aggregation as Sum > Chart Options: Stacking = Normal > Finish

Config steps = Chart type: Grouped Data Chart > Chart as Bar > Metric: Activity Duration > Players: Players in Team > Grouping: 1st level grouping by Player > Timeframe if needed: Off set Date Range, 0 off set Period > 4 Weeks Previous Period > Chart Options: Added highlights to highlight players of interest

Config steps = Chart type: Bubble > Metric: Injuries Received, Days Missed, Age > Players: Players in Team Timeframe if needed: I used Specific Date Range and set frequency as Season & aggregation as Sum > Finish

Config steps = Chart type: Timeseries > Chart as Column> Metric: Body Weight > Players: Players in Team > Timeframe if needed: Daily Average > Apply Model: Difference with Offset Period=0 and a 12 Month Previous Period Chart Options: Added highlight zones to emphasize acceptable differences.

Config steps = Chart type: Table > Metric: Various Wellbeing Metrics > Players: Players in Team > Grouping: 1st level grouping = Dataset, multi-series with 2nd grouping = Time Frame> Timeframe if needed: Whatever is needed, an offset would work well > Finish

Please use the following support channels to help further with any related questions/issues you may be having with your system.

Telephone:

0330 058 0303 - Our phone line is open Monday to Friday from 8:30am to 4:30pm

Email:

For Clients using the Premier League PMA system:

pmasupport@pma.premierleague.com

For all other Client:

supportdesk@thesportsoffice.com

For Clients from the IRFU:

IRFUSupport@thesportsoffice.com

Chat:

Our interactive chat bubble in the bottom right of your platform

Someone will aim to reply to your email within 24 hours given it isn’t on a weekend.