Calculating the Production Focus score using data exports
|Request to Publish|
|Version as of|
↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ Please Read Below ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
Enter your content below. Use the basic wiki template that is provided to organize your content. After making your edits, add a summary comment that briefly describes your work, and then click "SAVE". To edit your content later, select the page from your "Watchlist" summary. If you can not find your article, search the design pattern title.
When your content is ready for publishing, next to the "Request to Publish" field above, type "Yes". A Curator then reviews and publishes the content, which might take up to 48 hours.
↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ The above text will be removed prior to being published ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
Workforce Intelligence compares the actual production hours accumulated by a department or team to its expected hours, to calculate a production focus score.
Use case examples
Provide a business example to help users understand the objective.
Before you begin
Is it necessary to plan anything in advance, or are external steps using other tools required to achieve the goal? If any specific configuration procedures (how-tos) exist on Pega Community pages, you can link to those assets here by providing the URL.
Process/Steps to achieve objective
To calculate the score, you need the following values:
1. Pe – Total Expected Production Hours
2. Pa – Total Production Hours
The data export provides the Total Expected Hours value of a user for a given calendar day
In order to calculate the Pe value, the total expected hours (4.9 hrs. in above example) should be multiplied by production percentage target (which is 0.6). This will give the expected production hours (Pe = 2.9h)
Pa can be calculated by summing the production time of the user for a specific day.
The formula to calculate the score is =IF(Pa>(1.2*Pe),10,IF(Pa<Pe,(Pa/Pe)*8,10*Pa/Pe-2))
Steps to calculate the score using data export–
The following provides the steps to calculate score using the weekly data export of the user mentioned in above screenshot. The ex
1. Create a new pivot in a new sheet.
a. Add shift_date, user_name and category columns in the Rows section
b. In the values column –
i. Summation of time_seconds – 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)
ii. Max Value of expected_time_seconds (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 value in a new cell.
3. Calculate the Expected Production Hours (Pe) by multiplying the value with production percentage target (Production percentage target is 0.6 in this case)
4. Store the Production Total Time (Pa) and Expected Production Hours (Pe) in new cells.
5. Use the above formula to calculate the score.
The whole setup should look like this –
What do you expect the user to see or be able to do after they complete this design pattern?