I have set of questions answered by customers. Please check the attachment file. I am displaying the Customer Questionwise Dissatisfaction Trend with a bar chart using QNo as Dimension and expression as =Count({<AnsID={2}>}Customer)
Consider QNo.6[Do you have any other feedback?], if customer says 'Yes' means he is not satisfied for that perticular question and should come in Dissatisfaction Trend with expression =Count({<AnsID={1}>}Customer) How can I show both combination of expressions in one expression? which gives count of customers for Q1,2,3,4,5,7 where AnsID=2 and for Q6 where AnsID=2
Output should be 0 0 1 1 0 2 1 Q1 Q2 Q3 Q4 Q5 Q6 Q7
