Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

Dhrish
8 - Asteroid
Spoiler
Capture.JPG
myastarling
11 - Bolide

here's my solution!

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-02-06 145846.png
Sebastian_Chaieb2
11 - Bolide
11 - Bolide

My solution:

 

Spoiler
427.png

CeliaC_Silje
8 - Asteroid

Learnt something new about Summarize Tool today

(Wondering why Mode would not work though...)

Jonathon-Sheppard
8 - Asteroid

So - I went about this happily one way, without looking at the recommended solution file, and came up with my 1st solution (attached). It gave me the same results, but I wasn't happy that the dates ranges still needed to be input manually, and that I wasn't using the provided test input file with the date ranges.

 

So I had a glance at the recommended solution and thought I'd go about building a 2nd workflow that eliminated any need for manually inputting date ranges. This feels better because it a) means I was utilising the data given and b) improving the repeatability of the workflow by eliminating any need for manual changes (e.g. if someone changed the date ranges in an input file). 

 

I've attached both here.

RebekaMazuchova
8 - Asteroid

:)

Jennhoo
8 - Asteroid

My solution.

mbens123
8 - Asteroid

That was a fun one.

Kilbyflow_Designer
8 - Asteroid

Done!!

 

Spoiler
Challenge 427.jpg