topic Rank in proper order in App Development

Rank in proper order

waleeed_mahmood — Mon, 22 Jan 2024 20:48:23 GMT

Hello,

I have a table where i want to show top 10 sales employees based on Achievement. The issue is i cant seem to sort the Rank in descending order for the life of me. They are placed randomly and i cant figure out why.

Looking at the table below, Rank 1 should be assigned to Top Achievement but its not.

My rank formula is: aggr(RANK(Achievement formula,4,0),Sales Employee)

any idea how to fix that?

Table format is like :

Rank	Images	Sales Employee	Achievement
1	img1	SE1	36.8%
2	img2	SE2	35.7%
3	img3	SE3	18.0%
4	img4	SE4	30.3%
5	img5	SE5	27.2%
6	img6	SE6	27.7%
7	img7	SE7	234.5%
8	img8	SE8	5.5%
9	img9	SE9	68.0%
10	img10	SE10	7.1%

Thanks

Re: Rank in proper order

Anil_Babu_Samineni — Sun, 28 Jan 2024 18:06:35 GMT

@waleeed_mahmood perhaps this,

aggr(RANK(Achievement formula,4,0),

("Sales Employee", (NUMERIC, DESCENDING)))

Re: Rank in proper order

Aasir — Mon, 29 Jan 2024 01:07:41 GMT

Your case may be a cause of default sorting set in data manager. Please amend your formula like this. Hope this helps.

aggr(RANK(Sum({<Achievement={'*'}>} [Achievement]), 4, 0), [Sales Employee])

I just included a set analysis.

Re: Rank in proper order

waleeed_mahmood — Mon, 29 Jan 2024 16:32:24 GMT

Hi Anil,

I didnt know you could sort in aggr(). thanks.

Re: Rank in proper order

waleeed_mahmood — Mon, 29 Jan 2024 16:35:27 GMT

Hi Everyone,

Thank you for your support.

How i solved this issue was, i put an IF statement inside the aggr() and only showed RANK where RANK() resulted in top 10.

Thanks,