Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the table of surveys as followed
Count Overall Experience Recommend Visit
--------- --------------------------- --------------------- -----------
1 Extremely Satisfied Yes Yes
1 Dissatisfied No No
1 Satisfied Yes Yes
1 Satisfied Yes Yes
1 Extremely Satisfied No No
1 Satisfied Yes Yes
1 Dissatisfied No No
I want to create a graph similar the one attached.
Note in the graph for overall Satisfaction % = Extremely Satisfied Count + Satisfied Count / all count
Recommend % = Yes Count / all count
Visit % = Yes Count / all count
you can do it many ways
try to do it by making an island and creating an if/set analysis expression
check this qvw
Sorry cannot open the file
Hello,
In edit script use below script:
data:
LOAD * INLINE [
Count , Overall Experience, Recommend, Visit
1, Extremely Satisfied, Yes, Yes
1, Dissatisfied, No, Yes
1, Satisfied, Yes, No
1, Satisfied, Yes, No
1, Extremely Satisfied, No, No
1, Satisfied, Yes, No
1, Dissatisfied, No, No
];
island:
LOAD * INLINE [
dimension
Would You visit this hospitak again?
Would You recomend this hospital?
Overall Experience
];
- Now take ST table with Dimension as dimension and in expression add expression as
=if(dimension='Would You recomend this hospital?',
sum({$<Recommend={"Yes"}>}Count)/sum(Count),
if(dimension='Would You visit this hospitak again?',
sum({$<Visit={Yes}>}Count)/sum(Count),
if(dimension='Overall Experience',
sum({$<[Overall Experience]={'Satisfied','Extremely Satisfied'}, Visit={Yes}>}Count)/sum(Count))))
This is the script given by Pari Pari. Perfect solution for you.