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: * Calculate the total number of User Groups, the total number of members, and the percentage increase in membership between June 2023 and March 2025. * 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 Source: https://community.alteryx.com/t5/User-Groups/ct-p/usergroups Challenge 487_start_file.yxmd Challenge 487_solution_file.yxmd

Here is my soultion Challenge 487_start_file.yxmd

My Solution Challenge 487_Solution.yxmd 487 Solution.bmp

Great challenge enjoyed doing it Challenge 487_solution_file.yxmd

Challenge #487: User Group Analysis

AYXAcademy

Full Width - WC banner.svg

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:

Calculate the total number of User Groups, the total number of members, and the percentage increase in membership between June 2023 and March 2025.
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

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

Challenge 487_start_file.yxmd

Challenge 487_solution_file.yxmd

Data Analysis

Core

Basic

Accepted answers

All comments

rmassambane

487

Challenge+487_start_file.yxzp

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.

challenge_487_submission_EM.yxzp

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 😄

487 (User Groups).yxmd

abacon

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

Spoiler

Challenge+487_abacon.yxmd

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

Challenge+487_start_file.yxzp

lwolfie

Done!

Challenge+487_solution_LW.yxmd

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

Challenge+487_jrlindem_solution.yxmd

mmontgomery

c487

Spoiler

I used max members by month to determine delta

c487.yxzp

alineruizcampos

Spoiler

Challenge 487_Aline.yxmd

DaisukeTsuchiya

Spoiler

Challenge+487_start_file_DT.yxmd

Yoshiro_Fujimori

My solution.

I tend to forget counting User Group Leaders in the number...

Spoiler

Workflow

Challenge+487_YFujimori.yxmd

Qiu

@AkimasaKajitani Congratulations!

Spoiler

I think we missing something like "Start of June" in the problem description.
And there is no impact to the result, but I believe we need to update the "UserGroupName" as well, not only the URL.

Challenge+487_start_file-Qiu.yxzp

RWvanLeeuwen

here's my take

Spoiler

Challenge487_start_file - RWvL.yxmd

RolandSchubert

Spoiler

Challenge_487_solution_rsc.yxmd

Krzysiek

MySolution

Spoiler

Challenge+487_MySolution.yxmd

JBevan89

Spoiler

I think I could of done it a more efficient way, but as it is still summertime I'm just happy that I did it

Challenge+487_JB.yxmd

balajilolla3

Spoiler

Solution Attached

Screenshot 2025-08-21 070434.png

Challenge+487_start_file.yxmd

AkimasaKajitani

My solution!

Actually, I forgot how to solve this challenge when I submitted it, so I approached it with a fresh attitude😂

Spoiler

Challenge+487_start_file_AK.yxmd

Hub119

Spoiler

Took me a sec to realize I needed to count those pesky User Group Leaders as Members...
C487 Pic.png

Challenge487_CH Solved.yxmd

Kenda

Spoiler

Challenge+487_start_file.yxmd

olga_strubbe

Thank you, @AkimasaKajitani

This was a great challenge. I followed in your footsteps in solving it - this seemed an easier and more straightforward way in getting at the solution for me.

Spoiler

Challenge 487_User Group Analysis.yxmd

fdavy

Definetively not the most optimized one, but still works.

Challenge+487_FDA.yxmd

Dhrish

Solution

Challenge+487_start_file.yxmd

skichiban_hk

attached with the answer

clewis28

Spoiler

Challenge+487_clewis28.yxmd

TobiasFitschen

Spoiler

Challenge_487_solution.yxmd

anuelle

Solution

AN Challenge 487 Solution.yxmd

alexnajm

Done!

Spoiler

more tools than most, but I'm content
challenge 487.png

Challenge+487_start_file_Alex Abi-Najm.yxmd

EKasminsky

Nice little challenge. Slightly annoyed that "group leaders" and "members" are considered seperate people. Aren't group leaders members of their own group?

Kaz Challenge 487.yxmd

Amy_smart

Here is my solution.

Challenge487_8_25.yxmd

MojoAnalytics

Hi rmassambane,
Thanks for your answer; it helped me understand the working of Alteryx in a rather fun way.
I am still new to the tool, and your insights could help me better understand the workings of the field.

I had 2 Qs<

1. There are 3 entries in the start date month of June 2023. Why don't we collect data from all 3 entries and average them out?

2. Why did you choose the first entry date of the month instead of the last entry date of the month?

Thanks in advance

lisahitch95

Cute on once I figured out that MIN(Date) and MAX(Date) don't get me the same numbers!

Spoiler

487_Solution.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335