Challenge #487: User Group Analysis

[AYXAcademy]

Hi Community members,

A solution to last week’s challenge can be found here.

This challenge was submitted by @AkimasaKajitani. Thank you, Aki, for your submission.

The Alteryx Community hosts localized User Groups across the globe. Have you ever wondered how many people participate in these groups, or how many active groups exist?

Each User Group page displays the group name, the number of leaders, the number of members, the URL, and the region. The dataset below was created by web scraping User Group pages between June 2023 and March 2025. You can explore it here: Alteryx Community User Groups.

For this challenge, use the two datasets provided to complete the following tasks:

1. Calculate the total number of User Groups, the total number of members, and the percentage increase in membership between June 2023 and March 2025.
2. Identify the top five User Groups with the largest increase in members.

Notes:

• Task 2 applies only to User Groups that exist as of March 29, 2025.
• Some User Groups may have changed names during the data period. Use the Change history dataset to align names correctly.
• Round all calculation results to two decimal places.

Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.

Good Luck!

The Academy Team

Download Start File | Download Solution File

Source: https://community.alteryx.com/t5/User-Groups/ct-p/usergroups 

[rmassambane]

487

[Erin]

*Edit* After looking at @rmassambane 's solution, I see my mistake and it all checks out now. I was so close the first time - just missed one little thing... new solution attached. 

[Pilsner]

Great challenge. For part two, it took me a while to realise why my answers weren't matching, but I got there eventually.

Spoiler

For the total members, you have to add the group leaders to the number of members. It seems obvious once you see it, but I didn't realise straight away 😄

[abacon]

I am not winning any tool golf but this was a fun one.

Spoiler

[jtmoll]

I know I can get the exact same result if I place 6/4/2023 but I did max date for my workflow

Spoiler

Spoiler

[lwolfie]

Done!

[jrlindem]

This one drove me a up a wall for a hot minute...

• MIN date vs MAX date
• Assumption that all groups are those that existed as of March 29, 2025 instead of forcing that "just in case"
• Assumption over what Total Members included

All that said, I got there.  Fun one, for sure.  Stretched my problem solving at how to get at the right results by testing my data against the above bullets.

Spoiler

[mmontgomery]

c487

Spoiler

I used max members by month to determine delta

[alineruizcampos]

Spoiler