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 #48: Calculating Distribution Priority

carmenrapariz
8 - Asteroid
Spoiler
Challenge 48.PNG
pdave87
11 - Bolide

This one was more hands on data prep + transform but not possible without spatial analysis between the centroids. I have added insights into reporting to cover more practice.

 

Thanks to all SMEs as always. PFA my solution for reference 🙂

 

Regards,

Pratik

Erin
9 - Comet

I went with multi-row formula tools. Hind sight running totals may have been easier - and couldn't wrap my head around macros at the moment due to  current low caffeine intake. Time to go remedy that! 

 

Spoiler
BronzeFox_0-1635443109044.png

 

LiuZhang
9 - Comet
Spoiler
48.png

Was a bit confused on priority calculation initially, need to check to see that means.

alexnajm
16 - Nebula
16 - Nebula

Done

Anmol97
8 - Asteroid

Here's my solution

MCooper
8 - Asteroid
Spoiler
WC48.png
fvojtesek
8 - Asteroid

My solution.

jonathanwillis
8 - Asteroid

Here's my solution

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution: