Inline table is one of the easy solution. Go to the data load editor (script editor) and add the below code
Load * Inline [
Strongly Agree, 1
Strongly Disagree, 4
Not Applicable, 5
Make sure the column name is same as per your existing data model. So it will automatically linked with corresponding column. Also you can load this from external files like csv, Excel.
Say you have a table with the surveys like this:
Mapping load * inline [
applymap('Dim',Rating,null()) as Description,
Load Rating,count(Rating) as Response
group by Rating;
load * inline [
Load * Resident Tempdata order by Rating desc;
Thanks and Regards,
this is a little complex I'll go through it and try to understand it a bit.
to be a little more clear on the responses/intervals.
e.g. one survey question is "The instructor is clear and concise."
in that question, there were:
10 people that chose Strongly Agree
Agree - 8
Disagree - 5
Strongly Disagree - 4
Not Applicable - 5
I want to be able to come up with a mean score for that question.