Time Tracking + Analysis Dashboards

Time tracking dashboards provide project managers and operational leaders with a real-time view of project effort, billable work, and resource utilization. Rather than reviewing individual time entries one task at a time, dashboards aggregate time tracking data into meaningful summaries that help teams monitor project health, budget consumption, and delivery progress.

Within Moovila, these dashboards can be created at project, project portfolio and task levels, allowing users to analyze time records from different perspectives depending on their role and reporting needs.

There are several key metrics to keep in mind:

• Work Est.: The total number of hours scoped. This is different from the duration, which is the number of days granted for the work to be completed. For example, a task may require 3 hours to complete (work estimate), but it may be completed over the course of 2 days (duration).
• Work Est. Balance: The number of hours remaining for this work based upon the estimate and the number of hours logged (Work Estimate - Time Logged).
• Work Remaining: The number of hours of work outstanding. This number is based upon the work estimate and the percent complete indicated. For example, a task is estimated to take 10 hours to complete (work estimate) and it has been marked 50% complete. The work remaining will be 50% of those 10 hours, so 5 hours. (Work Estimate x Percent Complete)
• Time Logged – Actual hours logged against project tasks.
• Billable Hours – The total of logged time marked billable.
• Billable Hours Balance – The remaining billable hours available before reaching the project's scoped budget. (Work Estimate - Billable Hours)

Below are details for recommended time tracking dashboards at the Project, Project Portfolio, and Task levels. For more information on building dashboards and adding layouts, watch the video Creating Dashboards. Note that these are great starting points, but can always be tailored to your organization's needs, so keep that in mind as you're looking at the filters and date ranges.

 

Project Level Dashboards

Project dashboards provide a consolidated view of all time logged within a single project, helping project managers monitor estimates, actuals, remaining work, and billable effort.

1. Labor Qty by Project:
   Type: Consolidated Expenses: Expense Dynachart
   Custom Filter: Select Labor Expenses
   Value: Labor Qty
   Targets: Project Budget Labor
   Group: Project
   Sub-Group: None
   Chart Date Range: All Dates
    
2. Expense by Project
   Type: Consolidated Expenses: Expense Dynachart
   Custom Filter: Select Labor + General Expenses
   Value: Expense
   Targets: Project Budget
   Group: Project
   Sub-Group: None
   Chart Date Range: All Dates
    
3. Labor Cost
   Type: Task Panels: [Custom Panel]
   Custom Filter: None
   Panel Content: Data Grid
   Columns: Billable Hours, Billable Hours Balance, Due Date, Finance Labor - Actual, Finance Labor - Budget, Finance Revenue - Actual, Finance Revenue - Estimate, Finance Revenue - Remaining, Finance  - Total Margin Actual, Finance - Total Margin Estimate,  Name, Percent Complete, Resource Type, Schedule - Total Closed, Schedule - Total Hours, Start, Status, Time - Time Log, Work Estimate, Work Estimate Balance, Work Remaining
   Panel Footer: Totals
    
4. Billable Hours
   Type: Timecard Panels: Custom Panel
   Custom Filter: Billing Status: Billable
   Panel Content: Data Grid
   Columns: Billable Hours, Billable Total, Effective Date, Notes, Resource Type, Total Time
   Panel Footer: Totals

Project Portfolio Dashboards

Portfolio Dashboards aggregate time across multiple projects, making it easy to analyze time by project, person, work type, billing status, or cost code.

1. Total Hours by Project
   Type: Timecard Panels: [Custom Panel]
   Panel Content: Chart
   Chart Type: Vertical Bar Chart
   Chart Group: Project
   Chart Sum: Time
    
2. Hours by Person Last Two Weeks
   Type: Timecard Panels: [Custom Panel]
   Custom Filter: Select the team you wish to display from the Users listing if necessary.
   Panel Content: Chart
   Chart Type: Horizontal Bar Chart
   Chart Group: User
   Chart Sum: Time
    
3. Hours by Cost Code
   Type: Timecard Panels: [Custom Panel]
   Panel Content: Chart
   Chart Type: Doughnut
   Chart Group: Cost Code
   Chart Sum: Time
    
4. Labor Qty by Project
   Type: Consolidated Expenses: Expense Dynachart
   Filter: Select Labor Expense data
   Value: Labor Qty
   Targets: Project Budget Labor Qty

Task Dashboards

Task Views allow teams to review detailed time entries for individual tasks while still rolling those values into project-level reporting.

1. My Team's Time Last Month
   Type: Timecard Panels: [Custom Panel]
   Panel Content: Chart
   Chart Type: Vertical Bar
   Chart Group: User
   Chart Sum: Time
    
2. Time Cards for Approval
   Type: Timecard Panels: [Custom Panel]
   Filter: Status - Submitted
   Panel Content: Grid
   Columns: Billable, Billable Hours, Cost Code, Effective Date, Project Status, Total Time, User
   Footer: Totals
    
3. Rejected Time Cards
   Type: Timecard Panels: [Custom Panel]
   Filter: Status - Rejected
   Panel Content: Grid
   Columns: Cost Code, Effective Date, Notes, Project, Total Time, User
   Footer: Totals