alteryx Community

# 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.

## Challenge #427: Bookstore Sales Analysis

Alteryx

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!

9 - Comet

My solution:

Spoiler
17 - Castor
Spoiler
9 - Comet
Spoiler

16 - Nebula

Solution attached,

Spoiler
11 - Bolide

c427

Spoiler
16 - Nebula
Spoiler
17 - Castor

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

Spoiler
11 - Bolide
Spoiler

7 - Meteor
Spoiler

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

Solution 2:

Spoiler