Statistics

Filtering your Charts

Form:

Here you can choose to limit the data to one specific form that is in use on your project. Alternatively, select all available forms for a complete overview of your project.

Filter:

Here you can optionally apply a custom filter to your chart. The custom filters can be created within your Tickets tab and then applied to your charts.

Data

Group by

Select an attribute from your ticket forms that will be applied to your graph as the base axis. (X-axis If it is a column/line chart, Y-axis in case of a bar chart). For example, select date created if you want to analyse data by date, or assignee if you want to see more information about the work done by project team members.

Value

Count tickets:
This will show you the total number of tickets based on the attribute you have selected in the ‘Group by’ field.

Calculate sum over:
Selecting the calculate sum option will allow you to compare your selected ‘Group by’ tickets with the total sum of a selected numeric field. Please note that to use this value, you need to have selected a numerical field such as progress or another number or decimal field.

Calculate mean over:
Selecting the calculate mean option will allow you to compare your selected ‘Group by’ tickets with the mean sum of a selected numeric field. Please note that to use this value, you need to have selected a numerical field such as progress or another number or decimal field.

Maximum value of.. :
Selecting the maximum value option will allow you to compare your selected ‘Group by’ tickets with the Maximum value of a selected numeric field. Please note that to use this value, you need to have selected a numerical field such as progress or another number or decimal field.

Minimum value of..:
Selecting the minimum value option will allow you to compare your selected ‘Group by’ tickets with the minimum value of a selected numeric field. Please note that to use this value, you need to have selected a numerical field such as progress or another number or decimal field.

Stacked bar chart/ Plot multiple line chart

Stacked bar chart

A Stacked bar chart will allow you to break down and compare the bars on the chart as a whole.

When you select the stacked bar option, you will need to select an additional field. This additional field will be shown as additional segments or categories within the bar. Different colours will be used to illustrate the different categories within the bar. For example, you can select assignee and then select ticket status to create a stacked bar chart showing the status of each team member’s tickets.

Plot Multiple Line chart

When you select the plot multiple line option, you will need to select an additional field. A multiple line graph shows the relationship between independent and dependent values of multiple sets of data.

Board options

Edit Board

Clicking on ‘Edit board’ will allow you to edit the name of the board that you are currently viewing.

Delete Board

Clicking delete board will allow you to delete the current board you are viewing

Refresh data

Clicking ‘Refresh data’ will refresh any data that might have been entered into your PlanRadar account. This allows you to make sure the charts you are viewing are up to date with the newest information.

Excel export

Clicking on Excel export will export all charts on your current board as an excel file. Each chart will be represented on a separate sheet within the Excel file.

Further filtering options

At the very top of the statistics page you can further filter your charts by selecting a project, a layer or any custom filters. You can also set date ranges.

Adding charts to reports

You have the option to add charts directly into your report templates. To do this, navigate to the templates tab via the navigation bar once you have finished creating your charts.

Open the template you wish to add your charts to. You will see a ‘Add charts’ button. This button is available on every template page except for the tickets page.

 

Once you have clicked on ‘Add charts’, you can select which charts you would like to add to the report. You can also choose their size by changing the chart width and height.