Help ---- SQL Script
- by Vinoj Nambiar
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