RANKING

cpanchor — Fri, 07 May 2021 07:21:34 GMT

HI ,

I want to derive the rank for the second column.

I am using this expression: aggr(rank(total(count(distinct [Person ID])),1,1),question)

n is calculated as :count distinct (person id)

After using the above expression I am not able to see Rank 1 in table. Rank starts with 2.

in this case n=197 is highest so all the rows having 197 should be rank 1 and so on.

can anyone help?

question	Interested people in topic	options for question
ADDRESSING INJECTION-RELATED QUESTIONS	14.1% ( n = 60)	a
ADDRESSING INJECTION-RELATED QUESTIONS	14.1% ( n = 60)	b
ADDRESSING INJECTION-RELATED QUESTIONS	14.1% ( n = 60)	c
HEARING PATIENTS' EXPERIENCES	36.4% ( n = 155)	d
HEARING PATIENTS' EXPERIENCES	36.4% ( n = 155)	e
HEARING PATIENTS' EXPERIENCES	36.4% ( n = 155)	f
HEARING PATIENTS' EXPERIENCES	36.4% ( n = 155)	g
INTERACTING WITH DIRECTLY	19.2% ( n = 82)	h
INTERACTING WITH DIRECTLY	19.2% ( n = 82)	i
INTERACTING WITH DIRECTLY	19.2% ( n = 82)	j
LOCATING OR CHANGING MY TREATMENT CENTER	3.8% ( n = 16)	k
LOCATING OR CHANGING MY TREATMENT CENTER	3.8% ( n = 16)	l
LOCATING OR CHANGING MY TREATMENT CENTER	3.8% ( n = 16)	m
MANAGING ONGOING RE-AUTHORIZATION AND INSURANCE APPROVALS	46.2% ( n = 197)	n
MANAGING ONGOING RE-AUTHORIZATION AND INSURANCE APPROVALS	46.2% ( n = 197)	o
MANAGING ONGOING RE-AUTHORIZATION AND INSURANCE APPROVALS	46.2% ( n = 197)	p
MEETING FAMILIES AND PATIENTS	25.4% ( n = 108)	q
MEETING FAMILIES AND PATIENTS	25.4% ( n = 108)	r
MEETING FAMILIES AND PATIENTS	25.4% ( n = 108)	s
MEETING FAMILIES AND PATIENTS	25.4% ( n = 108)	t
NAVIGATING THE LOGISTICS ASSOCIATEDAND	14.1% ( n = 60)	u
NAVIGATING THE LOGISTICS ASSOCIATEDAND	14.1% ( n = 60)	v
NAVIGATING THE LOGISTICS ASSOCIATEDAND	14.1% ( n = 60)	w
NAVIGATING THE LOGISTICS ASSOCIATEDAND	14.1% ( n = 60)	x

Re: RANKING

Digvijay_Singh — Fri, 07 May 2021 14:55:27 GMT

May be try something like below -

num(rank(total(count(distinct [Person ID])),4)

Else share the rank output in the table you shared above.