Challenge #48: Calculating Distribution Priority

[carmenrapariz]

Spoiler

[pdave87]

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]

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

[LiuZhang]

Spoiler

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

[alexnajm]

Done

[Anmol97]

Here's my solution

[MCooper]

Spoiler

[fvojtesek]

My solution.

[jonathanwillis]

Here's my solution

[BSilverblatt]

Thanks for the challenge! Here is my solution: