Challenge #487: User Group Analysis

[Amy_smart]

Here is my solution. 

[TurboToad]

#487

Had some differences in the first task taking the max members for June and March by Group.

Spoiler

Also used this formula to calculate percentage increase

• Subtract final value minus starting value
• Divide that amount by the absolute value of the starting value
• Multiply by 100 to get percent increase
• If the percentage is negative, it means there was a decrease and not an increase.

[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

[Mathangopal]

This was funn.. but had issues understanding what does the March 2025 and June 2023 Members really mean

[binuacs]

Spoiler

[SteveY02]

To my understanding, there are few detail need to be clear before solution this quiz:

Task 1:

1. se the **earliest** record in **June 2023** as the baseline and the **latest** record in **March 2025** as the endpoint.

2. **Percentage increase:** Calculate as

(total member in June 2025 - total member in March 2023) / total member in March 2023 * 100 , keep 2 decimals.

[Carolyn]

It took me awhile to realize that I needed to add the UG Leaders into the UG Members number to match the solution in the Start File. However, I'm not sure if that's correct. I'm looking at the Seattle UG and the Leaders are included in the Members list. If I take the 256 UG members today (8/26), inclusive of the leaders, and subtract out the 15 people who joined after March 2025, I get 241. That matches with the data in the file. So I'm reasonably certain that the Members number already includes the Leaders. 

Workflow solution:

Spoiler

[Yanxuliu]

Challenge #487: User Group Analysis

[lisahitch95]

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

Spoiler

 

[mattnason1]

My challenge 2 results are different because I treated new groups as increasing by that number of members.  If I ignore that and leave those null values to fail then I have the same result.