Loading
HelpCommunityTraining Center

ArticlesBite Size Analytics: How to Build a Dashboard for Project Task Time and Task Revenue by Day

Knowledge Article

Bite Size Analytics: How to Build a Dashboard for Project Task Time and Task Revenue by Day

Task time reporting functionality is available in the Project Reporting dataset. This feature allows users to analyze data points such as total actual hours, variance between actual and planned hours, and associated revenue and costs. Queries and dashboards can be built using the Project Task, Project Task Assignment, and Task Time objects. Filters are available for project, task, resource, and time period.

  • Jun 26, 2025
  • Knowledge

Title
Bite Size Analytics: How to Build a Dashboard for Project Task Time and Task Revenue by Day
URL Name
Bite-Size-Analytics-How-to-Build-a-Dashboard-for-Project-Task-Time-and-Task-Revenue-by-Day
Summary
Task time reporting functionality is available in the Project Reporting dataset. This feature allows users to analyze data points such as total actual hours, variance between actual and planned hours, and associated revenue and costs. Queries and dashboards can be built using the Project Task, Project Task Assignment, and Task Time objects. Filters are available for project, task, resource, and time period.

Objective

This article introduces you to the task time reporting functionality in the Project Reporting dataset. You can answer such questions as:

  • What is my monthly total of actual hours by task and resource?
  • How many hours have been submitted on this task to date?
  • What is the variance of actuals versus planned hours on this task to date?
  • What is the revenue and costs on this task to date? 
  • Show me all tasks related to a resource on this task
  • Show me all tasks related to a milestone on this task
Product Area
PS Cloud - Reporting & Analytics
Release Version
Environment

This functionality has been available since the Summer ‘23 release of Foundations and is in PS Cloud Core Analytics.

Procedure

The project reporting dataset combines many different objects related to projects, in this case, we are going to look at 3 objects in the dataset:

  • Project Task
  • Project Task Assignment
  • Task Time

All queries (lens) and dashboards you build can be filtered by: 

  • Project
  • Task
  • Region-Practice-Group
  • Project name
  • Project manager
  • Resource
  • Time

See the video below for an introduction to the task time feature in the dataset and how it is structured so you can understand the under-the-hood workings.

 

Additional Notes

For any feedback or requests for future Bite Size Analytics, post in the Reporting Chatter group.

Reporting & AnalyticsProfessional Services CloudCustomer Success CloudDatasetsBuilding DashboardsBite Size AnalyticsFinancial Management Cloud
Was this article helpful?
00
Upload Files
Recommendations
No results for undefined
Loading
Knowledge:Bite Size Analytics: How to Build a Dashboard for Project Task Time and Task Revenue by Day