Table of Contents
Custom Reports Use Cases
Required Permissions
Navigating to Custom Reports
Generating Custom Reports
Editing, Duplicating, Deleting and Sharing Custom Reports
Exporting Custom Reports
Generating Charts
Bar Chart
Line Chart
Pie Chart
Explaining Custom Reports Indicators
Common Use Cases
Capacity, Scheduled, and Tracked Hours
Availability in Hours Grouped by Department
Tracked Hours Grouped by Projects
Custom Reports Use Cases
Your organization needs to track particular data types to ensure it achieves its strategic goals. This is why creating personalized reports tailored to your needs is crucial. Thankfully, BigTime Resource Management is here to help.
The main advantages of Custom Reports:
- You can save a report
- You can share a report with your teammates inside Foresight Connect
- You can choose whether the report should be automatically updated or saved as a static data snapshotReport date ranges can be set as fixed or with automatic updates (last month, this month, last year, etc.)
Required Permissions
You must have specific permissions to create, edit, and view reports. Read this article to learn more about user rights and permissions in Foresight Connect.
Navigating to Custom Reports
Once you have appropriate permissions, log into Foresight Connect in the manager role and click on the Reports tab in your main navigation sidebar. Then, open the Custom Reports sub-tab. You can view, generate, or edit a custom report here.
Generating Custom Reports
The image below shows how to generate a Custom Report correctly. To make the report easier to read, click on it and open the report editor modal. Then, select the "Simple Structure" checkbox and click Save and Open to return to the main report view. This will produce an easy-to-read report.
Editing, Duplicating, Deleting and Sharing Custom Reports
To edit, duplicate, share, or delete a report, look to the icons on the right side of your report rows. These icons correspond to different actions, as follows:
Blue Pencil: edit a report.
Green Pages: duplicate a report.
Blue Share: share a report.
Red Trash Can: delete a report.
You will see a checkmark in the Is Shared column if you have successfully shared the report. The report will be visible in the Custom Report sub-tab, under the Reports tab, for every manager who can access it.
Exporting Custom Reports
You don't have to create a chart to download your report. If you use the auto-update option, the data will be updated automatically. Remember to download the report to save data from a specific time range. Otherwise, it will automatically update every time new data is logged.
Generating Charts
To generate a chart, uncheck the “Simple Structure” checkbox in the report editing modal.
In the images below, you will find short step-by-step instructions on how to generate charts. When configuring the chart, no report data is changed. You can switch chart types depending on your needs.
Bar Chart
| Access Report ➡ Scroll down to the bottom of the page ➡ Click Add chart button ➡ Configure chart ➡ Click Bar/Line Chart ➡ Type the Title ➡ Click Add datasets button ➡ Configure the chart in a pop-up window ➡ Choose Bar Type ➡ Click OK button |
Line Chart
| Access Report ➡ Scroll down to the bottom of the page ➡ Click Add chart button ➡ Configure chart ➡ Click Bar/Line Chart ➡ Type the Title ➡ Click Add datasets button ➡ Configure the chart in a pop-up window ➡ Choose Line Type ➡ Click OK button |
Pie Chart
| Access Report ➡ Scroll down to the bottom of the page ➡ Click Add chart button ➡ Configure chart ➡ Click Pie Chart ➡ Type the Title ➡ Click Add datasets button ➡ Configure the chart in a pop-up window ➡ Click OK button |
Explaining Custom Reports Indicators
The table below presents explanations of values found in Custom reports.
| Value | Description |
| Scheduled Active Minutes | Scheduled time expressed in minutes in the Active status |
| Scheduled Active as FTE | Scheduled time expressed in FTE in the Active status |
| Scheduled Active Hours | Scheduled time expressed in hours in Active status |
| Scheduled Reserved Minutes | Scheduled time expressed in minutes in the Reserved status |
| Scheduled Reserved as FTE | Scheduled time expressed in FTE in the Reserved status |
| Scheduled Reserved Hours | Scheduled time expressed in hours in the Reserved status |
| Scheduled Draft Minutes | Scheduled time expressed in minutes in the Draft status |
| Scheduled Draft as FTE | Scheduled time expressed in FTE in the Draft status |
| Scheduled Draft Hours | Scheduled time expressed in hours in the Draft status |
| Scheduled Minutes | Scheduled time expressed in minutes in Active, Reserved, and Draft statuses |
| Scheduled as FTE | Scheduled time expressed in FTE in Active, Reserved, and Draft statuses |
| Scheduled Hours | Scheduled time expressed in hours in Active, Reserved, and Draft statuses |
| Scheduled Billable Hours | Time scheduled in billable assignments expressed in hours. |
| Scheduled Non-Billable Hours | Time scheduled in non-billable assignments expressed in hours. |
| Contract Capacity Minutes | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it isn’t reduced by time-offs, and it’s expressed in minutes. |
| Contract Capacity as FTE | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it isn’t reduced by time-offs, and it’s expressed as FTE. |
| Contract Capacity Hours | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it isn’t reduced by time-offs, and it’s expressed in hours. |
| Capacity Minutes | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, which is reduced by time-offs and expressed in minutes. |
| Capacity as FTE | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it is reduced by time-offs, and it’s expressed as FTE. |
| Capacity Hours | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it’s reduced by time-offs and expressed in hours. |
| Billable Capacity Minutes | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it’s reduced by time-offs and assignments with an Assign Leftover Capacity checkbox checked. The value is expressed in minutes. |
| Billable Capacity as FTE | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it’s reduced by time-offs and assignments with an Assign Leftover Capacity checkbox checked. The value is expressed as FTE. |
| Billable Capacity Hours | A maximum work time that an individual staffer can handle within a given time frame. The value comes from a staffer’s contract, and it’s reduced by time-offs and assignments with an Assign Leftover Capacity checkbox checked. The value is expressed in hours. |
| Availability in Hours | The person's available time remains to be allocated. Contract Capacity reduced by time-offs, assignments with an Assign Leftover Capacity checkbox checked, and assignments in Active status. The value is expressed in hours. |
| Availability as FTE | The person's available time remains to be allocated. Contract Capacity reduced by time-offs, assignments with an Assign Leftover Capacity checkbox checked, and assignments in Active status. The value is expressed as FTE. |
| Time Off Minutes | Approved time-off expressed in minutes |
| Time Off Hours | Approved time-off expressed in hours |
| Time Off Days Count | Approved time-off expressed in days (number of days with approved time-offs) |
| Time Off as FTE | Logged time in billable and non-billable projects expressed in FTE |
| Input Minutes | All time logged for both billable and non-billable projects, recorded in minute format. Input minutes account for both submitted and unsubmitted time. |
| Input as FTE | Time logged in billable and non-billable projects expressed as FTE |
| Input Hours | Time logged in billable and non-billable projects expressed in hours |
| Input Billable Hours | The number of billable Time Entries expressed in hours. These hours can be logged in billable and non-billable projects. |
| Input Non-Billable Hours | The number of non-billable Time Entries expressed in hours. These hours can be logged in billable and non-billable projects. |