I want to calculate average "Estimated Effort" for project associated to each EVP.
For example, Wilber has two projects, one has an estimated effort of 2 and the other one is a 3, so I want to create a table that pulls the information for Wilbert and states looks something like this:
Report
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Here is the source table:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
For example, Wilber has two projects, one has an estimated effort of 2 and the other one is a 3, so I want to create a table that pulls the information for Wilbert and states looks something like this:
Report
EVP | Num of Projects | Average Est Effort |
Mike | 2 | 4 |
Wilber | 2 | 2.25 |
Hank | 3 | 1 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Here is the source table:
Project Title | EVP | Est. Project Size (T-shirt Sizing) | Application Dependencies | Estimated Effort |
Remove Sybase (Architecture) | Mike | 4 | 4 | 4 |
Pre-Requisites to Conversion to Oracle | Wilber | 3 | 1 | 2 |
Quote Replacement | Mike | 4 | 4 | 4 |
OEM Lock Down | Wilber | 2 | 3 | 3 |
Locker Pickup P2 | Hank | 1 | 1 | 1 |
POS Restriction to Purchase when BSS has a STD xref. | Hank | 1 | 1 | 1 |
Modify POS New Store Database build to support version 7.3 | Hank | 1 | 1 | 1 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>