Where to start?

I have a dataset (attached) and I am trying to figure out where to start if I wanted to find how many states is summer the most common season for a sighting. I want to be able to do some kind of distinct count on the state/season pair but that seems like a lot of steps. Maybe there is a simpler tool to use? I am new to Alteryx. Thanks in advance!

Example Data.xlsx

Designer Cloud

Best Practices

Accepted answers

Yoshiro_Fujimori

Hi @mekulski

Welcome aboard!

If I read correctly, I believe there are 29 states.

Workflow

Please check the configuration of each tool.

The combination of Sort Tool and Sample Tool (with grouping) is a very handy pattern.

I hope this helps.

countStates.yxzp

All comments

Yoshiro_Fujimori

Hi @mekulski

Welcome aboard!

If I read correctly, I believe there are 29 states.

Workflow

Please check the configuration of each tool.

The combination of Sort Tool and Sample Tool (with grouping) is a very handy pattern.

I hope this helps.

countStates.yxzp

OTrieger

@mekulski
The best way for your to learn it will be in Alteryx Academy, there are great interactive lessons and challenges. Understanding of the basic things will be a good foundation for learning the more complex things, therefore do invest your time to go through these lessons.

Good luck with your learning, that would be the correct place to start.

mekulski

Wow I did not realize that you could use the sample tool like this. I also missed that you can use summarize on the same column more than once. Thanks for pointing that out. Much simpler than what I was trying to do.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703