I have two fields that I would like to calculate ranks for. The calculated ranks will be used in a new calculated field. One of the fields does not need to be aggregated before being ranked, but the other field does need to have an average calculated before being ranked. When ranking, if two items in a field have a same value they should be given the same rank. Is this possible? I don't see a rank function in Tableau.