2 Replies Latest reply: Dec 16, 2014 7:55 AM by buvaneswari subramanian RSS

    How to get avg value in calculated dimension


      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

       

      MONTHAprApr
      SITECategoryCriteriaBase GMTWt %TargetActual
      USG1Drive 2014 Business ResultsMission Critical Infrastructure99.807.2099.899.84
      USG1Drive 2014 Business ResultsMission Critical Application99.806.4099.899.63
      USG1Drive 2014 Business ResultsIT Request: Infrastructure SSR97.004.0096.697.2
      USG1Drive 2014 Business ResultsIT Request: Application SSR96.005.6095100
      USG1Drive 2014 Business ResultsInfrastructure: 95%tile Cycle time1.002.4010.44
      USG1Drive 2014 Business ResultsApplication: 95%tile Cycle time2.002.4020.84
      USG1Drive 2014 Business ResultsCustomer Satisfaction: IT Service Desk 4.00 2.40 44.39
      USG1Drive 2014 Business ResultsCustomer Satisfaction: SSR Rating4.002.4044.92
      USG1Drive 2014 Business ResultsNumber of VOC due to IT0.002.4000
      USG1Drive 2014 Business ResultsCost Savings by actual cost per K Revenue1.701.201.551.92
      USG1Drive 2014 Business ResultsContribute talent and resources to achieve other site's projects1.002.8002
      USG1Drive 2014 Business ResultsRetain top 30% performers1.000.8000
      UTLDrive 2014 Business ResultsMission Critical Infrastructure99.807.0099.8100
      UTLDrive 2014 Business ResultsMission Critical Application99.807.0099.8100
      UTLDrive 2014 Business ResultsIT Request: Infrastructure SSR97.002.5099.72100
      UTLDrive 2014 Business ResultsIT Request: Application SSR96.006.0099.53100
      UTLDrive 2014 Business ResultsInfrastructure: 95%tile Cycle time1.002.500.270.2
      UTLDrive 2014 Business ResultsApplication: 95%tile Cycle time2.002.500.20.08
      UTLDrive 2014 Business ResultsCustomer Satisfaction: IT Service Desk4.002.5044.43
      UTLDrive 2014 Business ResultsCustomer Satisfaction: SSR Rating4.002.5044.7
      UTLDrive 2014 Business ResultsNumber of VOC due to IT0.002.5000
      UTLDrive 2014 Business ResultsCost Savings by actual cost per K Revenue1.701.000.890.974
      UTLDrive 2014 Business ResultsContribute talent and resources to achieve other site's projects1.003.0000
      UTLDrive 2014 Business ResultsRetain top 30% performers1.001.0011