When downloading the Resource Utilization report (after clicking the Download button), use the new filters to retrieve only a set of data you need.
Available filters include:
|Groups and users||Specifies groups or users to be included in the report.|
|Time scale (Day, week, or month)||Defines the time interval for grouping data in the report.|
|Time frame||Date range for data to be included in the report.
Note: When using Week or Month in time scale, the time frame must start on the first day and end on the last day of week, or month.
Click the Flat tab at the bottom of the Excel file to view exported report data in the flat/plain text format, where each record is listed in a separate line, with no structural relationship between records.
For example, if the date range is from October 1 to December 31, grouped by month, the report displays 3 records for each user – one for each month.
Flat file format allows you to create pivot tables out of a large data set for reporting flexibility, where you can view your data grouped in any way you like.
Examples of Pivot tables created from flat file data
My team weekly utilization
In this report (download), the new My team weekly utilization tab is added. The tab includes a pivot table created from the Flat tab data that represents weekly utilization for a team of three users with few weeks of data. Conditional formatting is used to highlight the relationshipt between billable utilization and target utilization.
Utilization by team
In this report (download) two additonal tabs are added with pivoted data from the Flat tab:
- Team utilization grouped by manager with a line chart
- Monthly utilization with high-level KPIs for all resources grouped by team.