Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #43: Inspire Europe '16 Grand Prix (L2)

bjkay30
8 - Asteroid

Here is my submission.

 

Spoiler
bjkay30_0-1609862259515.png

 

clmc9601
13 - Pulsar
13 - Pulsar

My solution

mceleavey
17 - Castor
17 - Castor

I'm not very quick because I keep faffing about...

 

Spoiler
1. Created the points on a map and used the Spatial Match tool to associate Locations with Postcodes. I then summed, grouping by area and counting the rows. I then sorted descending by number of casualties and took the first one.
Answer: LS8 - 1385
2. Isolated the stats for 2014 and 2015, then isolated those after September 1st. Two streams, one of the full years, one with the dates restricted to after September 1st. Formula to calculate %.
Answer = 36.844229
3. Applied multi-row formula to step 2.
Answer = 0.951074
Workflow.PNG

I keep forgetting to time them...



Bulien

Hub119
8 - Asteroid

Solution attached.

aiahwieder
8 - Asteroid

Wondering if I got this right -- since some of the points seem to be outside ALL the postcodes?

etechman
8 - Asteroid

this was a good challenge and I learned about some new tools.  

ReconBen
8 - Asteroid
Spoiler
ReconBen_43.JPG

apathetichell
18 - Pollux

Completely missed the key detail that I was only looking for Leeds casualties and kept scratching my head why my answer didn't work...

rcarog
8 - Asteroid

Solution attached.

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1616781992426.png