Hi Community,
We posted the solution JSON file to Cloud Quest #36. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
- Download the provided JSON file containing your starting data and workflow files.
- Upload Start Cloud Quest XX.json file to your Analytics Cloud library.
- All necessary datasets are contained within Text Input tools in the workflow.
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.
Scenario:
The Big Five personality traits—also called the five-factor model—are used to describe human personality across five key dimensions: Extraversion, Agreeableness, Conscientiousness, Neuroticism, and Openness to Experience.
Each person in this dataset completed a survey with 50 statements, rating themselves from 1 to 5 on each factor. Your job is to calculate scores for each of the five traits based on these answers.
The questions and how they relate to each trait are provided in another dataset (Personality Factor Questions). For each question, it tells you which trait it belongs to and whether it’s scored positive or negative. If Positive, use the rating as-is. If Negative, subtract that value.
Your Tasks:
- Calculate a raw score for each user and each trait by summing the scores across all 10 questions for that trait.
- Apply the official scoring adjustments from OpenPsychometrics.org to compute the final scores:
- Output a final table showing each user’s score for all five traits.
|
Extraversion
|
20 + raw score
|
|
Agreeableness
|
14 + raw score
|
|
Conscientiousness
|
14 + raw score
|
|
Neuroticism
|
38 - raw score
|
|
Openness:
|
8 + raw score
|
Hint: Combine the Transpose and Cross Tab tools to reshape the dataset.
Image generated by ChatGPT, June 20, 2025, OpenAI, https://chat.openai.com.
Data Source: https://www.kaggle.com/tunguz/big-five-personality-test#data-final.csv
Earn Cloud Quest badges:
After completing your quest, head back to your Analytics Cloud library:
- Download your workflow solution file.
- In your reply, attach both your JSON solution file and a screenshot of your workflow.
- Keep submitting—every solution gets you closer to earning more Cloud Quest badges!
Here’s to a successful quest!
- The Academy Team
Download Start File | Download Solution File
some questions like the 11th or 12th within a factor, were lost in this workflow... I would not formally report outcomes on this data before this would be resolved - good thing we can easily see what can be improved