Counting results from a survey and assigning a new role

laura5 · 2024-11-19T05:09:56.585Z

Hi fellow Bubblers!

I created a survey to help identify the creative expressions of people signing up for my app. I am going to use the creative expression to match each user with a coach. Below is a screenshot of the first question in the survey for reference.

Screenshot 2024-11-18 at 9.58.36 PM940×1071 136 KB

I created an Option Set for the Creative Expressions. Please see screenshot below.

Screenshot 2024-11-18 at 9.46.37 PM1170×1033 74.9 KB

I thought it would be best to treat the Creative Expression similar to a ‘user role’, saving the CreativeExpression to the User data type->CreativeExpression(OS). I set this up in my database as shown below.

Screenshot 2024-11-18 at 9.48.10 PM386×234 10.4 KB

However, I am having a hard time creating a workflow that counts the user’s survey answers, sorts them based on creative expression from highest to lowest, takes the first one (which would be the creative expression with the highest count) and then assigns that creative expression as a role to the user.

I was able to have the user’s answers counted based on they creative expression each answer selection represents.

Screenshot 2024-11-18 at 9.51.18 PM876×198 8.53 KB

However, I can’t seem to do the next part, which is assign the role to the user as the creative expression with the highest count. I don’t know what workflow to set up to make that happen. Would it be a backend workflow?

This is what I want to show the user once I’m able to assign the CreativeExpression. In the example below, ‘Artisan’ is the CreativeExpression(OS) of the current user. The headline and key traits are dynamically showing based on that option set.

Screenshot 2024-11-18 at 10.02.54 PM963×742 70.9 KB

Bonus points: Help me figure out how to make a pie chart using their creative expressions, where each slice is proportionate to the count of the creative expressions they selected. Basically, using the data below to create the pie chart. Ideally, the slices are organized from largest to smallest and maybe even slices with ‘0’ are left out.

Screenshot 2024-11-18 at 10.05.27 PM863×194 8.52 KB

By the way, here are some screenshots from the database showing relevant data types and setup. I made it a little harder on myself too by allowing users to select two answers per question, which translates to two creative expressions lol.

Screenshot 2024-11-18 at 10.07.56 PM523×557 32 KB

Screenshot 2024-11-18 at 10.07.39 PM1206×570 73.5 KB

Thank you much! I’ve been trying for 2+ days to get the survey results to display how I would like them to. I sooo appreciate any and all help!

system · 2025-01-28T05:10:28.684Z

This topic was automatically closed after 70 days. New replies are no longer allowed.