Rank in the bar chart

[kanalavs]

Hi Friends,

I am new to the community. I have the requirement to display bar chart based on highest priority.

If a person has priority 1 and 2 then we need to consider the priority based on the latest date.

Please help how to write the rank script for the bar chart. You can find the data below.

Fruit	Person No	Rank	Date
Apple	SXXXX1	1	20180718
Apple	SXXXX2	1	20180925
Apple	SXXXX3	1	20181119
Apple	SXXXX4	1	20180625
Apple	SXXXX4	1	20181016
Apple	SXXXX5	1	20180108
Apple	SXXXX6	1	20180815
Apple	SXXXX7	1	20180813
Apple	SXXXX7	1	20180814
Orange	SXXXX1	2	20180718
Orange	SXXXX6	2	20180815
Banana	SXXXX2	3	20180925
Banana	SXXXX6	3	20180815
Grape	SXXXX1	5	20180718
Banana	SXXXX3	3	20181026
Grape	SXXXX5	5	20171124
Orange	SXXXX5	2	20180101

Attached Sample of the chart:

[kanalavs]

Hi Aiolos Zhao, 

i  have written the expression as follows but the outcome is similar like you. some of the persons are tagging   to both CA and DA. Please advise me how to restrict the persons. 

Dimension:

AGGR(FirstSortedValue([Action],RANK_Level),[C_ID])

Expression:

Count(distinct(C_ID))

[uacg0009]

Have you seen my qvw?
I said I add the data source for testing the expression, have you seen it?
I think my expression is what you want, if not, please tell me what you want using my data.