# Calculate Production Focus score using weekly/monthly data exports

Calculating the Production Focus score using data exports / This is the approved revision of this page, as well as being the most recent.

# Calculate Production Focus score using weekly/monthly data exports

Description How to calculate Production Focus score using weekly/monthly data exports 8.5 Pega Workforce Intelligence Workforce Intelligence

Workforce Intelligence compares the actual production hours accumulated by a department or team or associates to their expected hours, to calculate a Production Focus score.

Clients like to combine and compare weekly or monthly aggregate data exports with additional (external) metrics generated by third-party systems. For example, they would like to compare Production Focus score with Claims productivity metrics. Using the weekly or monthly aggregate data exports, they can calculate the Workforce Intelligence Production Focus score and use/compare it with additional (external) metrics.

## Before you begin

### Understand the terms required for Production Focus calculation

To calculate the Production Focus score, we need the following values:

1. Pa – Actual production hours (recorded by Pega Robot Runtime)
2. Pe – Expected production hours (calculated by Workforce Intelligence based on the expected hours and production percentage target)
3. Production % - The percentage of time spent in production applications and websites during the expected hours or shift.

Note: The data export provides the Total Expected Hours value of a user for a given calendar day.

Sample Screenshot from the Summary page highlighting the values required for calculation:

##### Calculate Expected production hours (Pe)

Mathematical Formula - Total Expected hours * Production % = Expected production hours (Pe)

Example -

In the above screenshot, the total expected hours is 9.5h. This value should be multiplied by production % which is set to 0.5 (by Workforce Intelligence administrator).

Expected production hours (Pe) = 9.5 * 0.5

After multiplying the two values, the expected production hours (Pe) is 4.8h

Actual production hours (Pa) can be calculated by summing the production category time of the user for a specific day.

##### Calculate Production Focus Score

Mathematical Formula = IF(Pa>(1.2*Pe),10,IF(Pa<Pe,(Pa/Pe)*8,10*Pa/Pe-2))

## Prepare the data export file to calculate the Production Focus score

Use the following steps to calculate the score using the weekly data export of the user mentioned in above screenshot:

1. Select the data and create a new pivot in a new sub-sheet.
• Add shift_date, user_name and category fields under the Rows section of the pivot.
• In the pivots, value column, add the following fields -
• Sum of time_seconds field
• This will provide the total time for a specific day, for a specific user and by different categories
• Rename the column to Total Time (secs)
• Max Value of expected_time_seconds field
• The data export provides the total expected time, which is same for specific day, specific user and for every category.
• Rename the column to Total Expected Time (secs)
2. Store the Total Expected Time (secs) value in a new cell.
• You can convert this value from secs to hrs. in a new cell.
3. Calculate the Expected Production Hours (Pe) by multiplying the Total Expected Time (secs) value with production % (production % is 0.5 in this example)
• You can convert this value from secs to hrs. in a new cell.
4. Store the Actual Production hours (Pa) and Expected Production Hours (Pe) in new cells.
5. Use the Production Focus Score formula to calculate the production score.

## Results

The whole setup should look like this: