Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #427: Bookstore Sales Analysis

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

 

Hi Maveryx,

 

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

 

This challenge was submitted by Ramesh Neelamana and has been modified to align with our learning objectives. Thank you, Ramesh, for contributing to this excellent challenge!

 

A bookstore wants to analyze book sales over a specified period to determine whether sales are increasing, decreasing, or remaining stable.

 

Your task is to investigate book sales for each 6-month period ending in March, April, and May of 2024. For example, when analyzing March, include the sales for March plus the preceding 5 months. The March 2024 analysis should include sales from October 1, 2023, to March 31, 2024, and similarly for April and May.

 

Calculate the total number of books sold for each analyzed period and identify the most popular book sold during that period.

 

For this task, you are provided with two datasets: one containing book sales data from 2021 to 2024, and the other containing the specific periods of time that require analysis.

 

Need a refresher? Review these lessons in Academy to gear up:

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Flo_P
9 - Comet

My solution:

Spoiler
image.png
Luke_C
17 - Castor
Spoiler
image.png
nSpire
9 - Comet
Spoiler
427.png

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
image.png
mmontgomery
11 - Bolide

c427

Spoiler
c427.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
alexnajm
17 - Castor
17 - Castor

Probably could've been done faster, but coffee needs to kick in 

Spoiler
Screenshot 2024-06-03 091627.png
ahsanaali
11 - Bolide
Spoiler
427.png

alexgibson
7 - Meteor
Spoiler
Challenge 427 solution.png

Fun solution. I tried two different ways of completing it as it's good to expanding my way of thinking.

Solution 2:

Spoiler
alexgibson_0-1717423480415.gif