i have a dataset that has 1 row per runner, and a race id , (so a many to one relationshio) it also has an additional column with a $ value for each runner.
I can use the summarize tool to group by the race id and then count the runners , but I would like to have an additional few columns where I count based on a criteria of the $ value.
How many in that race are below $5 , how many are below $10 etc,
This is so I can have a dataset for the next step with machine learning.
What would be the best tool to use, I have the latest designer with intelligence suite.