Hello all, I am looking for guidance here.
I have a data set that contains a function, questions and answers. not all questions have the same set of responses, so that trellis doesn't help me
I am trying to answer questions with the below sample set such as
1 - How many people who are new to using the tool would recommend it to a friend
2 - how many people who used the previous tool are from which function.
I was trying to create a chart with Function and Answer as a dimension, then put the answers and percentage of the response to the answer on a barchart
It would be one chart per question / answer set
I did a cross table to get the question/answer data table
DataLoad:
CrossTable(Question, Answer)
LOAD Function,
[How long have you worked in Tool?],
[The purpose of Tool is clear],
[How likely is it that you would recommend Tool to a friend or colleague?]
I also have inline tables which define valid answers to questions
Gemeric:
LOAD * INLINE [
ResultSortOrder,AnswerGeneric,RD,GN,BL
1,Strongly Agree,33,102,172
2,Agree,103,169,207
3,Neutral,254,224,144
4,Disagree,239,138,98
5,Strongly Disagree,178,26,43
];
duration:
LOAD * INLINE [
PreviousSortOrder,AnswerPreviousSolution,REDs,GRN,BLU
1,Strongly Agree,33,102,172
2,0-6months,103,169,207
3,6months to 1year,254,224,144
4,longer than one year,253,219,199
];
I just cannot determine the proper set analysis to get the first chart to just show the duration.
I end up with all possible answers. I am working on one chart per question as an end goal.
thanks in advance