Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We have a requirement to showcase data in pivot table and for that i need help in writing expression. We have a skill survey data in which people from different geographical regions has filled the survey form. There are approxametly 65 questions in survey form and each question has 4 options as below.
-No-Knowledge
-Begineer
-Intermediate
-Advanced
I have created a pivot table in which I have selected the dimensions as Application, Region and in the expression i want to show count of users falling under either of category based on below assumption.
1) Out of 65 questions, 1 user has selected answered 53 questions as "No knowledge",10 questions as intermediate, 1 as begineer and 1 as advanced. We need to compare this values with total 65 and since "No Knowledge"(53 answers) is > 80%of65(which is 52), This guy should fall under "No Knowledge" category. Similarly we need to count how many users fall under "No Knowledge", "Intermediate", Begineer or Advanced category for each Region.
Regards
Bibhu
Any sample Data?
or
You can write 4 expression for , like?
-No-Knowledge
Expression: count({<Options={'No-Knowledge'}>} distinct UserID)
Similarly for others as well..Will this make sense?
hi sharmabi
You can use a dimension as column (pivot table functionality, refer screen shot below) and can use sum(measureName) as expression.
Hope this will help.
Thanks,
Punit
Hi
Provide sample data