Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is the scenario:
WT % is the dimension. This must be grouped based on taking average across Site, Category, Criteria, Base GMT, Year and Month. So that it will appear as single row. Please suggest. Many thanks. Buvana
MONTH | Apr | Apr | ||||
SITE | Category | Criteria | Base GMT | Wt % | Target | Actual |
USG1 | Drive 2014 Business Results | Mission Critical Infrastructure | 99.80 | 7.20 | 99.8 | 99.84 |
USG1 | Drive 2014 Business Results | Mission Critical Application | 99.80 | 6.40 | 99.8 | 99.63 |
USG1 | Drive 2014 Business Results | IT Request: Infrastructure SSR | 97.00 | 4.00 | 96.6 | 97.2 |
USG1 | Drive 2014 Business Results | IT Request: Application SSR | 96.00 | 5.60 | 95 | 100 |
USG1 | Drive 2014 Business Results | Infrastructure: 95%tile Cycle time | 1.00 | 2.40 | 1 | 0.44 |
USG1 | Drive 2014 Business Results | Application: 95%tile Cycle time | 2.00 | 2.40 | 2 | 0.84 |
USG1 | Drive 2014 Business Results | Customer Satisfaction: IT Service Desk | 4.00 | 2.40 | 4 | 4.39 |
USG1 | Drive 2014 Business Results | Customer Satisfaction: SSR Rating | 4.00 | 2.40 | 4 | 4.92 |
USG1 | Drive 2014 Business Results | Number of VOC due to IT | 0.00 | 2.40 | 0 | 0 |
USG1 | Drive 2014 Business Results | Cost Savings by actual cost per K Revenue | 1.70 | 1.20 | 1.55 | 1.92 |
USG1 | Drive 2014 Business Results | Contribute talent and resources to achieve other site's projects | 1.00 | 2.80 | 0 | 2 |
USG1 | Drive 2014 Business Results | Retain top 30% performers | 1.00 | 0.80 | 0 | 0 |
UTL | Drive 2014 Business Results | Mission Critical Infrastructure | 99.80 | 7.00 | 99.8 | 100 |
UTL | Drive 2014 Business Results | Mission Critical Application | 99.80 | 7.00 | 99.8 | 100 |
UTL | Drive 2014 Business Results | IT Request: Infrastructure SSR | 97.00 | 2.50 | 99.72 | 100 |
UTL | Drive 2014 Business Results | IT Request: Application SSR | 96.00 | 6.00 | 99.53 | 100 |
UTL | Drive 2014 Business Results | Infrastructure: 95%tile Cycle time | 1.00 | 2.50 | 0.27 | 0.2 |
UTL | Drive 2014 Business Results | Application: 95%tile Cycle time | 2.00 | 2.50 | 0.2 | 0.08 |
UTL | Drive 2014 Business Results | Customer Satisfaction: IT Service Desk | 4.00 | 2.50 | 4 | 4.43 |
UTL | Drive 2014 Business Results | Customer Satisfaction: SSR Rating | 4.00 | 2.50 | 4 | 4.7 |
UTL | Drive 2014 Business Results | Number of VOC due to IT | 0.00 | 2.50 | 0 | 0 |
UTL | Drive 2014 Business Results | Cost Savings by actual cost per K Revenue | 1.70 | 1.00 | 0.89 | 0.974 |
UTL | Drive 2014 Business Results | Contribute talent and resources to achieve other site's projects | 1.00 | 3.00 | 0 | 0 |
UTL | Drive 2014 Business Results | Retain top 30% performers | 1.00 | 1.00 | 1 | 1 |
Provide sample data please...
You can consider this as a sample