Finding the max of one field by two variables

[ryanliefer]

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!

[Ladarthure · Accepted solution]

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).

[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!

[Ladarthure]

You're welcome :)