Group by and then a count of occurrence by field value

[robertporternz]

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. 

[ShankerV]

Hi @robertporternz 

Can you please share the sample data.

[robertporternz]

No problems, here is a sample 

[willemb]

It sounds like you just need a Formula before the Summarize.

Create the new fields for each record first, then summarize after that:

[ShankerV]

Hi @robertporternz 

One way of doing this.

Many thanks

Shanker V