Generating a report
To generate a report, click the Reports menu item in the top bar and then select the report to generate from the left.
Time tracking report
Use the time tracking report to get a summary of logged hours with the ability to narrow down and see detailed information on each time log.
Go to Reports > Time tracking to run the report.
The report supports grouping and summaries of data based on User, Date, Project, and Task type.
|
The main report consists of the following columns:
|
| Tip: The report can be sorted by clicking on the column headers. |
Adding filters
On the right-hand side of the report, a filter panel can be toggled that allows you to narrow down the data in the report based on Time range, Projects, Project status, Users, and Groups.
Getting details
You can click on an item in the main report to open up the details spreadsheet where more information for the item selected is displayed, such as a list of each time log a user has submitted.
Certain details in this spreadsheet can be clicked to open the sidebar for that Task, User, Project, etc...
The details spreadsheet also supports the grouping of data and can show time logs summarised based on User, Date, Project, Task, Task type, or individual time logs.
Exporting
To export the Time tracking report, click the Export button.
- Exporting as Excel will export the raw timelogs from the main spreadsheet with the currently selected filters but without any grouping applied.
|
Please note: If no date filter is specified |
Projects report
With the Projects report, it is possible to generate summary reports on projects in ftrack. Go to Reports > Projects to run the report.
|
The main report consists of the following columns:
|
| Tip: The report can be sorted by clicking on the column headers. |
Adding filters
On the right-hand side of the report, a filter panel can be toggled that allows you to narrow down the data in the report based on Task due date, Task type, Projects, Project status, Users and Groups.
Getting details
To get further details on a project you can click on an item in the main report.
|
This will open the details pane with summary information about:
|
Project breakdown report
| Please note: This report is only available for administrators and project managers. |
The project breakdown report displays logged time, based on month, and is presented divided into project and task types.
Follow these steps to generate a report:
-
Click Reports in the top bar.
-
Select Project breakdown.
-
Select a month from the date picker in the Month field.
-
Add additional filters such as:
-
Resources: select specific users to include in the report.
-
Project: select specific projects to include in the report
-
Expand: select projects to expand and display the time-log breakdown per task type.
-
-
Click Run.
| Please note: Depending on the number of projects, users, and types, the time it takes to generate the report may vary. |
Exporting
To export the Project breakdown report click Export and select the desired export format.
This will export the main spreadsheet with the currently selected filters.
User breakdown report
| Please note: This report is only available for administrators and project managers. |
The User breakdown report displays logged time based on the month.
Follow these steps to generate a report:
-
Click Reports in the top bar,
-
Select User breakdown.
-
Select a month from the date picker in the Month field.
-
Add additional filters such as:
-
Project: select a single project you would like to run the report on.
-
Options: Select whether you want to see users who have:
- Logged time: Will display all users who have entered time logs during the selected month
- Missing time: Will display all users who have not entered time logs, or who's time logs on a given day do not equal the Workday length configured for your workspace in System settings > Scheduling > Settings.
-
-
Click Run.
|
Please note: Depending on the number of projects, users, and types, the time it takes to generate the report may vary. Limitation: The Project filter will only filter for users who have been assigned to the selected project via the Teams tab, but does not filter their time logs to only those logged against the selected project. |
Once the report has been run, an overlay can be applied to the data that will highlight any user time logs that are less than your configured Workday length.
Workload report
The Workload report provides an overview of the utilization of resources across a studio, helping you make decisions on work assignments and resource planning.
Go to Reports > Workload to run the report.
The report displays global summaries for utilization, a number of tasks, and projects within a certain time range. It can also provide workload details for specific users.
The top insights display a summary of all the users listed in the filtered spreadsheet.
|
The report spreadsheet consists of the following columns and can be sorted by clicking on the column headers:
|
Utilization, Allocated and Unallocated calculation
Calculating the utilization, allocated, and unallocated time for a user uses several different inputs.
Let’s go through an example to clarify how these values are computed today.
Here we have started by adding a single task using the Gantt chart with a start date on Monday, end date on Sunday, a bid of 5 days, and assigning a single user to it.
Now, let’s look at the same week in the Workload report:
See how the assigned user has utilization of 100%:
This is based on the user having a total availability of 40 hours for the selected week, with the total availability counted as the number of workdays (Monday - Friday) multiplied by the hours in a regular workday.
| Please note: The number of hours available on each workday is based on the Workday length setting. (System settings > Scheduling > Settings) |
The bid of the task is 5 days (40 hours) which matches exactly the available time, so the utilization is 100%.
If you look closely at the Gantt in the example though, you will see that the task was actually spread over the weekend as well. In the current version of the report, weekends are excluded from the calculation.
Looking at the summary bar, you will see the total utilization displayed is 50%.
This is because one of the users we are filtering has not been scheduled at all.
Once we expand the duration of the task to be two weeks and update the workload report, then the utilization of the assigned user has decreased to 50%, and the total utilization has decreased to 25%.
This is because the number of days the bid is divided across has doubled, so the applicable bid amount for the week we are looking at is now 20 hours rather than the previous 40.
| Limitations: When calculating the utilization and allocated time, we currently don’t support bank holidays or vacations. For example, if one of the days during the scheduled period in the above example is a bank holiday, the user’s utilization will still be calculated as 50%. |
Adding filters
On the right-hand side of the report, a filter panel can be toggled that allows you to narrow down the data in the report based on Time range, Users, and Groups.
|
Please note: The workload report requires at least one active date filter to be calculated. |
Viewing details
You can click on a user row in the report spreadsheet to see more information on about the underlying data in a details panel.
The details panel contains insights for the selected user and a spreadsheet displaying all assigned tasks during the time range.
|
The spreadsheet contains the following columns:
|
Exporting
To export the Workload report click Export > Excel:
This will export the main spreadsheet with the currently selected filters.