We posted the solution JSON file to Cloud Quest #4. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Download the provided JSON start file and upload it into your Analytics Cloud library. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Understanding client feedback has been critical for companies to improve their products and services. In your role as a data analyst, you are assigned the task of analyzing client feedback to measure their satisfaction and enhance the quality of services at your company.
For this task, you will need to manually connect the two provided datasets:
Hint 1: Client and Professional are distinct fields. The Client field displays the Company Name, while the Professional field shows the individual client's name.
Hint 2: Start by filtering the data at the beginning to only include entries where Status = Evaluated.
Hint 3: Remember to combine the dataset using Client ID and RequestNumber as the key fields.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file as a JSON file. You can also capture a screenshot of your finalized workflow in Designer Cloud. Include your JSON file and workflow screenshot as attachments to your comment on this post.
Some day we'll be able to use multi-row calcs in Alteryx Cloud :)
Until that day comes, here's my approach to finding the "top 3 values" accounting for ties
Nice simple one
Here's my solution
How do you convert the file to a .json? I can't find the article on this.
To create a .json file, go to the Analytics Cloud home and select the Library tab. Find the workflow you'd like to create a .json file for and then select the vertical ellipses in the far right column. Select Download from the drop down list. This will open a "save file" dialog to save your file.
Good luck.