Where to start?

[mekulski]

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! 

[Yoshiro_Fujimori · Accepted solution]

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.

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