I was wondering if there was a way to create a calculated value such that you can find the count of one specific value in a data set to the count of all values in a data set.
For example, I have a data set of races, people and places finished. I would like to use a calculated field to calculate win percentage for a particular person by looking at the count of number of first place finishes "1" divided by the count of all values in the "finish" column (1,2,3,4,5,6...etc).
Thank you.
For example, I have a data set of races, people and places finished. I would like to use a calculated field to calculate win percentage for a particular person by looking at the count of number of first place finishes "1" divided by the count of all values in the "finish" column (1,2,3,4,5,6...etc).
Thank you.
