PSA Project Burnup Dashboard

The PSA Project Burnup dashboard enables you to:

View project scope and how much work has been delivered and billed.
Compare your projects' billings to the budget over the duration of the project.
Compare your projects' hours to the project planned hours over the duration of the project.
Get a breakdown of your project's billed hours, milestones, expenses, and miscellaneous adjustments by month

The dashboard is created as part of the PS Cloud Core Analytics app and displays data from the Billings dataset. For more details of the fields used by the PSA Project Burnup dashboard, see Billings Dataset PS Cloud Analytics Output Fields.

PSA Project Burnup Dashboard Guide

The charts in the PSA Project Burnup dashboard group the estimates vs actuals (EVAs) data from the billings dataset using their related time period type. By default the dashboard gives preference to the month time period type, and if this is not available it uses the following priority:

Month (Default)
Week
Quarter
Year
Other

The dashboard contains the following elements.

PSA Project Burnup dashboard schematic highilghting the key elements of the dashboard.

PSA Project Burnup Dashboard Elements (Billings View)
Element Number	Name	Description	Calculation	Referenced Calculation	Source Dataset
1.	Budget	Total amount of the project’s budget records, including the following budget types and their respective change requests: Customer Purchase Order Vendor Purchase Order Work Order The change requests for each type contributes to the total cumulative budget. For example, the budget for a project with a budget type of customer purchase order is 50,000 USD. If you add a customer purchase order change request for 10,000 USD, the total cumulative budget of 60,000 USD is displayed on the dashboard.	Filtered by `Type = ”Budget”` Measure = `Billings Value`, Group by `Subtype`	`Type` Is a calculated field which defines the record type of a record in the Billings Dataset. For example, Budget, Est v Actuals, Expense, Milestone,Misc Adjustments, or Timecard. `Billings Value` Is a field which is calculated differently depending on which `Type` of record is used. For Expenses, Misc. Adjustments, and Budgets, this is the Amount field. For Milestones. this is the Milestone Amount field. For Timecards, this is the timecard split's Total Billable Amount field. For Estimates Vs. Actuals, when the Scheduled Bill Rate is Daily Rate field is selected then this is the Scheduled Bill Rate multiplied by estimated Days field. Otherwise, this is the scheduled bill rate multiplied by the value of the Estimated Hours field.	Billings See Billings Dataset PS Cloud Analytics Output Fields for more information.
2.	Projected	Total projected billings amount for the project.	Actual + Scheduled	See detail for Actual and Scheduled below.
3.	Actual	Actuals to date on project, broken down on the bar by timecards, milestones, misc adjustments, expenses.	Filtered by Subtype = “Actual” Measure = Billings Value Group by Type	Type gives you the breakdown of type of actuals. For example, timecards, milestones, misc adjustments, expense.
4.	Scheduled	Remaining scheduled (future periods only).	Filtered by Subtype = “Scheduled” Measure = Billings Value Note: See Help topic ‘Billings Flow Intermediate Processing’ for notes on currency handling for Billings Value (ValueBillings)	Scheduled value come from Est v Actuals object type Billings value explanation: see above (1).
5. Project Trend line graph
6.	Project Currency/Corporate Currency	View project burnup data in project currency or corporate currency.
7.	Budget line	Shows total budget for the project including change orders.	Filter by Subtype= “Budget” Measure=Billings Value Group	Billings Value here is the Amount field from the budget object in PSA.
8.	Actual line	Shows cumulative actuals to date. If required, current month can be displayed as actual data. For more information on choosing your current month display, see [BAN-33432]Using the PSA Project Burnup Plus Dashboard Configuration Page.	Filter by Subtype= “Actual” Measure=Billings Value Group by End Date	End Date is a field in Billings dataset which is calculated depending on what ‘type’ of record: For Timecards, the end date is the timecard split End Date field. For Expenses, the end date is the Expense Date field. For Misc. Adjustments, the end date is the Effective Date field. For Milestones, if the subtype is actual the end date is the Actual Date field. If the subtype is scheduled the end date is the Target Date field. For Estimates Vs. Actuals, the end date is the End Date field.
9.	Scheduled line	Shows scheduled values for future periods only. If required, current month can be displayed as scheduled data. For more information on choosing your current month display, see [BAN-33432]Using the PSA Project Burnup Plus Dashboard Configuration Page.	Filter by Subtype = “Scheduled” Measure = Billings Value Group by End Date This value is cumulative	End Date explanation: see above (6)
10.	Billings Distribution bar chart	Periodic view of billings amount for actuals and scheduled values. The actuals and scheduled values include sub categories and they are the same as that of KPIs. The actuals and scheduled values include sub categories and they are the same as that of KPIs. For more information, see PSA Project Burnup Billings and Hours KPI.	Filter by Type is not “Budget” Measure = Billings Value Group by End Date (by month) and Subtype	Billings Value explanation: see above (1) End Date explanation: see above (6)

Note: The Billings Distribution chart Actual and Scheduled legends consist of additional types. The Actual bar includes Expenses, Milestones, Misc Adjustments, and Timecards. The Scheduled bar includes Est Vs Actuals and Milestones. These additional types are not displayed in the Legends as well as the charts. However, you can hover over the bars in the chart to view tooltips with the breakup of the additional types.

PSA Project Burnup Dashboard Elements (Hours View)
Element Number	Name	Description	Calculation	Referenced Calculation	Source Dataset
1.	Planned Hours	Filter by Subtype = “Actual” Measure = Total Hours Group by Type	Filter by Type=”Budget” Measure=Total Hours	Total Hours is a calculated field in the Billings dataset. For Budgets, the dataflow uses the project's planned hours field. For Estimates Vs. Actuals, this is the Estimated Hours Field. For Milestones, this is the Billable Hours in Financials field. For Misc. Adjustments, and Expenses, this value is zero. For Timecards, this is the Total Hours Field.	Billings
2.	Projected	Total projected hours for the project.	Actual + Scheduled	See detail for Actual and Scheduled below.
3.	Actual	Total cumulative actual hours for the project. Note: On the hours view of the Project Burnup Dashboard, the actual hours are derived from the timecards and not from the milestones.	Filter by Subtype= “Actual” Measure=Total Hours Group by Type
4.	Scheduled	Total remaining scheduled hours for the project.	Filter by Subtype= “Scheduled” Measure=Total Hours Group by Type
5.	Project Trend line graph	Cumulative actual hours to current period, scheduled hours for future periods of the project versus planned project hours. Current month can be displayed as actual or scheduled data. For more information on choosing your current month display, see [BAN-33432]Using the PSA Project Burnup Plus Dashboard Configuration Page.	Filter by Subtype= “Budget”or “Actual” or “Scheduled’ Measure=Total Hours Group by End Date
6.	Hours Distribution bar chart	Periodic view of hours for actuals and scheduled values. The actuals and scheduled values include sub categories and they are the same as that of KPIs. For more information, see PSA Project Burnup Billings and Hours KPI.	“Budget” Measure=Total Hours Group by End Date (by month) and Subtype

PSA Project Burnup Buttons and Selectors

The PSA Project Burnup has the following buttons and selectors.

Project Burnup Plus Buttons and Selectors
Button or Selector	Description
Corporate Currency/Project Currency	Toggle this button to view the dashboard in corporate currency or project currency.
Billings	Switches the type of data to display billings.
Hours	Switches the type of data to display hours.
	Opens the dashboard's configuration page.

PSA Project BurnupBillings and Hours KPIs

The following KPIs and KPI subcategories are listed under Billings and Hours.

Project Burnup Plus Dashboard KPI Subcategories
KPI	Subcategory
Budget Planned Hours	Customer Purchase Order Vendor Purchase Order Work Order Customer Purchase Order Change Request Vendor Purchase Order Change Request Work Order Change Request
Projected	Total Actual Total Scheduled
Actual	Actual Timecards Actual Expenses Actual Milestones Miscellaneous Adjustments
Scheduled	Estimates Vs Actuals Scheduled Milestones