Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a pivot chart whr dimensionwise i had to calculate avg count percentage,
used the expression,
avg(aggr(Count(FILE_NO)/Count(total<C_QUESTION> FILE_NO),C_QUESTION,C_STATUS
))this works fine, see the pic
Status | Compliance | NA | NCompliance | Total | |||||
Process | Question | % | Count | % | Count | % | Count | % | Count |
Fixing | A | 100% | 30 | - | - | - | - | 100% | 30 |
Fixing | B | 100% | 30 | - | - | - | - | 100% | 30 |
Fixing | C | 70% | 21 | 30% | 9 | - | - | 50% | 30 |
Fixing | Total | 90% | 81 | 30% | 9 | - | - | 75% | 90 |
but the desired O/P should be,
Status | C | NA | NC | Total | |||||
Process | Question | % | Count | % | Count | % | Count | % | Count |
Fixing | A | 100% | 30 | - | - | - | - | 100% | 30 |
Fixing | B | 100% | 30 | - | - | - | - | 100% | 30 |
Fixing | C | 70% | 21 | 30% | 9 | - | - | 50% | 30 |
Fixing | Total | 90% | 81 | 10% | 9 | - | - | 75% | 90 |
whts happening is its not counting the misssing values, so taking avg as 30 instead of 10 %,
Please somebody let me know wht chnages to b done in the expression used, wht wrong hav i done ????
Can you provide a sample of the data prior to it being aggregated?
hey mark,
cant do tht
Can't do it or wont do it?
If it's "wont" and the reason is the data is senative, you could always scramble the data.
It's difficult to help you without knowing what your data is.
both !!!!! already have a vio la tion on ma name, so avoiding the risk
whts scr am ble will try tht video,
thanks n respond to my post tomorrow.
Hey Experts / Gurus,
any suggestions Pls.....