This lesson describes:
• Two choices for building a Measure
• How to create a manual Measure
• How to create a number data type Measure
• How to use Toolbar Options or type the formula manually
• How to Validate Formula
• How to create a Cost data type Measure
• How to link Measure to a portfolio or strategy
• How to Recalculate Measures
[MUSIC PLAYING]
Measures are calculated fields that you design. Use them to monitor project performance in portfolios or assess alignment to strategic goals. In this video, we will explore the components that make up a measure and then step through creating two examples.
1. Measures are defined at the workspace level.
Measures are defined at the workspace level in summary and settings.
[MUSIC PLAYING]
2. Two choices for building a Measure.
You have two choices when building the calculation for your measure.
Use common math operations to create a formula based on existing project level fields such as forecast budget or actual duration, or base your measure on ones that already exist. For example, here's a measure totaling the forecast budget and another totaling the planned budget. You can create a new measure comparing the two.
3. Create a manual Measure.
You can also create a manual measure where the value is typed into the field rather than calculated.
4. Create a number data type Measure.
Let's start with creating a basic formula measure. We have a portfolio containing active, planned, and proposed projects. We need to track how many active projects are in the portfolio. We begin by adding a new measure called active project count. Each measure has a data type, cost, percentage, or number. This measure will use the number data type. Values are captured based on the frequency selected. We will capture this value weekly.
5. Toolbar Options to enter calculation.
We're now ready to enter our calculation. Use Toolbar Options to answer a formula, or if you are familiar with formula scripting, type the formula manually. In the aggregation type list, select Count and click Insert. The formula is pre-populated in the Actual section. For field, let's select Project ID to count all the projects in the portfolio.
[MUSIC PLAYING]
For the filter, let's filter on all projects that have a status of active.
[MUSIC PLAYING]
6. Validate Formula.
Use the Validate Formula button to ensure that the syntax is correct.
7. Create a Cost data type measure
Next, let's create a measure to track the planned budget for all the projects in the portfolio. The data type will be cost, and we will capture this value weekly. We'll use the sum aggregate for planned budget. We won't include a filter, so the total will reflect all the projects in the portfolio. Again, click Validate Formula to ensure the syntax is correct.
8. Link Measure to a portfolio or strategy.
After creating a measure, link it to a portfolio or strategy. Let's link the two measures we built to this portfolio.
[MUSIC PLAYING]
Next, go to the portfolio's Scorecard page to add the measures and view their data. Click the Settings button at the top of the page.
[MUSIC PLAYING]
9. Recalculate Measures.
The measures are initially blank when added to the scorecard. Click Recalculate Measures to run the calculations. When you receive a notification, the measures have been updated. Refresh the page. The Measure tile gives you the current value. Click the Measure Trend icon to view how the portfolio or strategy has performed over time. Click the Measure Definition view if you want to view the formula used to determine the values.
[MUSIC PLAYING]