Help ---- SQL Script
Posted
by Vinoj Nambiar
on Stack Overflow
See other posts from Stack Overflow
or by Vinoj Nambiar
Published on 2010-05-10T06:23:29Z
Indexed on
2010/05/10
6:34 UTC
Read the original article
Hit count: 262
Store No Store Name Region Division Q10(response) Q21(response)
2345 ABC North Test 1 5
2345 North Test 6 3
2345 ABC North Test 4 6
1st calculation
1 ) Engaged(%) = Response Greater than 4.5
3 (total response greater than 4.5) / 6 (total count) * 100 = 50%
Store No Store Name Region Division Q10 Q21
2345 ABC North Test 1 5
2345 ABC North Test 6 3
2345 ABC North Test 4 6
2) not engaged (%) = Response less than 2
1 (total response less than 2) / 6 (total count) * 100 = 16.66%
I should be able to get the table like this
Store No Store Name Region Division Engaged(%) Disengaged(%)
2345 ABC North Test 50 16.66
© Stack Overflow or respective owner
