Forum Discussion
Connecting multiple data points
Hello,
I am trying to analyze a survey answers which has 800+ rows based on multiple data points, from within the some questions answers. the survey has 119 questions, each question with 5 options.
For example
I want to classifiy each rows as
- Organized, semi organized, not organized.
by
Organized classification is
| Question number | Option |
| Question 1 | Option 2 |
| Question 5 | Option 3 |
| Question 6 | Option 4 |
| Question 13 | Option 5 |
| Question 44 | Option 1 |
And semi organized as for example
| Question number | Option |
| Question 1 | Option 3 |
| Question 5 | Option 1 |
| Question 6 | Option 5 |
| Question 13 | Option 2 |
| Question 44 | Option 4 |
is this obtainable? and how
thank you
4 Replies
matout ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Hello, thank you for the answer
I have a survey. with 119 question, each question is a column.
each answer for the survey is a row in the table.
for example
Company ID Bank Account? Accounting Practice Accountant? External Auditor Online Banking?
1 yes Accounting system Yes No No No
2 No Accounting records Yes No No No
3 Yes Accounting system Yes yes Yes No
I want to classify each company (row) as Organized, Semi Organized and Not organized.
based on thier answers to the questions.
For example, if a company has a bank accout, Accounting practice, Accountant, Registered trade name and Tax number
this company will be labeled as organized.
I have other criteria for semi organized and other for not organized
Is this obtainable and how?
Thank you
matout , a new column like
new column =
Var _1 = if([Bank Account]= "Yes" ,1,0) + if(not(isblank([Accounting Practice])),1,0)+ if([Accountant]= "Yes" ,1,0) + if([External Auditor]= "Yes" ,1,0) + if([Online Banking]= "Yes" ,1,0)
return
Switch( True() ,
_1 = 5, "Organized",
_1 >0 , "Semi Organized",
"Not organized"
)Change as per need
Hello, thank you for the answer.
this solution is helpful, however, there are 3 different values in the "Accounting practice" column.
How can I diffrentiate them, this is not just true or false.
