Set Analysis with Multiple Comparision

[#1]

Dear All,

How can we show the below two expressions in a Pie Chart so that it shows customer count for
Questions Q1,Q2,Q3,Q4,Q5,Q6 with specified condition. 

Dimension is Question_No.

Expressions:

Count({<Survey_Type={'Service'}, Question_No = {'Q3','Q5','Q6'},AnswerID = {'2'} >}Customer)

count({<Survey_Type={'Service'}, Question_No = {'Q1','Q2','Q4'},AnswerID = {'<9'} >} Customer)

[#2 · Accepted solution]

Thanks Sridhar, data not getting satisfied for second exp. thats the reason.

[#3]

Could you explain me what data is not getting satisfied, so that i could help you out.

condition for second part of the expression is below.

count({<Survey_Type={"Service"}, Question_No = {'Q1','Q2','Q4'},AnswerID = {"<9"} >} Customer)

as per the condition, only satisifying row are 3.

Service	Q1	Were all requested jobs done first time?	6	6	Rajesh
Service	Q2	Was service completed within promised delivery time?	8	8	Rajesh
Service	Q4	Was your vehicle delivered clean?	1	1	Rajesh

can explain me what is the problem.?

- Sridhar

[#4]

Dear Sridhar,

Thanks for your reply.

Our Sol. was correct, 2nd exp was not getting considered bcz there was not data which could satisfy 2nd exp.

Thanks,