Finding the max of one field by two variables

Hello,

I am looking to find the max value of one field by two variables and am having trouble returning this while keeping all of the fields I need. I attached a screen grab of the file I am manipulating and some empty columns of the desired outcome.

I am looking to find the Max "cases" by "zip code" while including which hospital the max cases belongs to.

Any ideas on the formula? I am guessing it's a max if in the formula tool but haven't been able to crack it.

Thanks for the help!

Example1.PNG

Datasets

Accepted answers

Ladarthure

Hello,

I don't think you will find your answer in formula itself, it might be a combination of sorts and sample or summarize and join (see attached wf).

max.yxmd

All comments

Ladarthure

Hello,

I don't think you will find your answer in formula itself, it might be a combination of sorts and sample or summarize and join (see attached wf).

max.yxmd

TylerNa

I would utilize the summarize tool and then group by zip code and hospital and then utilize the max function in the tool for cases. You can then add a sort tool to get the number of cases in a descending order.

ryanliefer

This is perfect... hardly utilize the Sample tool but It is exactly what I needed.

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703