Displaying 1 result from an estimated 1 matches for "date_st".
Did you mean:
datest
2005 Nov 01
1
percent rank by an index key?
...calculate the “percent rank”, where I define percent rank as rank/n.
(n is the number of numeric data points within each date-state grouping.)
This is what I am currently doing:
1. I create a “group by” field by using the paste function to combine date and state into a field called date_state. I then use the rank function to calculate the rank by date, by state.
2. I then add a field called “one” that I set to 1 if the value in income is numeric and to 0 if it is not.
3. I then take an aggregate sum of “one”. This gives me a count (n) for each date-state grouping....