Cloud Quest #40: Life Changing VR

[AYXAcademy]

Hi Community,

We posted the solution JSON file to Cloud Quest #39. 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!

1. Download the provided JSON file containing your starting data and workflow files.
2. Upload Start Cloud Quest 40.json file to your Analytics Cloud library.
3. 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:

A local arcade recently introduced a new virtual reality (VR) experience and surveyed users last week to assess headset performance. They want to analyze the results to determine which headset brand received the highest ratings, as they plan to purchase more of those models.

The arcade uses three VR headset brands: HTC Vive, PlayStation VR, and Oculus Rift. Analyze results for each brand, grouping users by ages 18–28, 29–39, 40–50, and  51+. The dataset includes each user’s Duration (minutes spent in VR) and Motion Sickness Rating (1–10, with higher values indicating more discomfort)

Ideally, users feel little motion sickness regardless of how long they use the headsets. Use the following Fun Score formula to assess the balance between duration and discomfort:

Fun Score = (Motion Sickness ÷ 60) × Duration

Using this formula, identify the brands and age groups where more than 20 users had a Fun Score less than 1, which the arcade considers LIFE CHANGING!

Fun Score scale:

9+	Refund
8+	Really sick
7+	Sick
6+	Dizzy
5+	Feeling weird
4+	Pretty good
3+	Fun
2+	Great!
1+	AMAZING
<1	LIFE CHANGING!

Hint: Create Age Group categories using IF, THEN, ELSEIF, THEN, ELSE, ENDIF syntax.

Image generated by Google Gemini, July 31, 2025.

 

 

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

[Carolyn]

Solved!

Spoiler

When I calculated the Fun Score, I used the CEIL formula to round up to the nearest whole number, so I could then group by the numbers.

[Erin]

Snuck in a Switch formula for practice since I don't use it often!

Spoiler

[NaiLo]

First Cloud workflow and first challenge submission! Comparing with the standard designer experience, it's like riding a bike but the handlebars are simultaneously too high and feel great? I give it a solid 5.2 fun score

Spoiler

[Carolyn]

@NaiLo And what's the motion sickness score? ;) 

[Qiu]

@Carolyn 
Nice question! 😁

[Qiu]

Fun one.

Spoiler

[RWvanLeeuwen]

I could have used less tools, but this way it was easier for me to share an image

Spoiler

I thought the sample size per group could be different, so I calculated fractions and sorted on that

[alexnajm]

Done! New badge time 😊 @Carolyn @Erin 

Spoiler

[Carolyn]

Woohoo @alexnajm! @Erin and I are calmly waiting for the badge and not impatiently checking like crazy women.........