Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

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
2 Replies
MVP
MVP

Re: How to get avg value in calculated dimension

Provide sample data please...

Not applicable

Re: How to get avg value in calculated dimension

You can consider this as a sample

Community Browser