Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate the number of customers

Hi All,

I need to calculate the no of customers who has given rating above 8(>8) and below 9(<9) and show them in the bar chart.

Am not getting correct values for first condition but am getting correct values for second condition.i dono where am doing mistake.

I've attached one sample application with this one.

Pls help me resolve this issue.It's urgent and i need to resolve within tomorrow noon.

2 Replies
Not applicable
Author

Hi All,

Am very sorry, i think i haven't explained clearly.

i have to consider only q2 to q8 for this calculation.

for ex:

if the customers give rating 9 or 10 for all the questions from q2 to q8 then satisfied and

if the customers give rating below 9 for any one of the customers from q2 to q8 then i have to consider that as dis-satisfied

As per my data i have 6 customers who has given rating 9&10 for q2 to q8 and only 4 has given below 9 for q2 to q8

so am getting correct value for dissatisfied but not for satisfied

sorry for the previous post. pls help me to solve this issue

Thanks in Advance.

Not applicable
Author

Hi

Anyone got an idea to solve my problem.

i would be very much greatful if you give solution.

Thanks in Advance.

Regards,

Arun