Hi All,
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
Thanks