Forum Discussion
Create Matrix From Five Columns
- Hi mahmoud,
Assiming your data is in the format you present In the query view you need to select all the questions columns and unpivoted them you will get a table with 3 columns:
Answers type
Attribute - questions
Count
Then in the matrix visual put the columns in the index below:
Answers type - Rows
Attribute - columns
Count - values
This should give what you.want.
Regards,
MFelix Hi mahmoud,
I was looking at your data and I would do a simple treatment of the information. I would take all the reply and ID column into one table and unpivoted them so would have a table with 3 columns: ID, Question, answer them would do a table with the rest of the question (age, start end date, ...) also with ID and keep it as is and then do the relationship between both tables by ID this would give you the reply that you need for your visuals but also a base with additional information to make the age of respondent visuals, etc...
Regards,
MFelix
Hi mahmoud,
This is one thing I noticed in your data, in your replies you have columns that are text and others that are numbers, problably you should divide between two tables one with the text values and another with the number values that way you could do the statistic analysis in you data and the quality also.
Regards,
MFelix
Hi MFelix
Thank you this good, I created the table you mentioned, then tried to create a matrix. Create a filter based on the attribute column but the value column I could not create a filter and it give the total rows numbers instead of the values I looking for.
Any suggestion to fix that?
Hi mahmoud,
This is one thing I noticed in your data, in your replies you have columns that are text and others that are numbers, problably you should divide between two tables one with the text values and another with the number values that way you could do the statistic analysis in you data and the quality also.
Regards,
MFelix