# This calculates the shot number or dose number of a set of id's by vaccine group/name in a Tableau calculated field. 

{ PARTITION [id field number], [Vaccine Group Name/Code field]: { ORDERBY [vaccination date field] ASC: RANK() } }