Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the expression below to get the rank of a field named "File_Name", but the results change whenever I select another field. How can I get it to always display the same rank compared to all "File_Name"?
aggr(rank(count({<Status={'OT'},File_Name=>}Status)/Count({<File_Name=>}Status)),File_Name)
Any help would be appreciated.
Can you post the file here so I can test off that?
Adding a 1 in the set analysis should ignore all selections:
aggr(rank(count({1<Status={'OT'},File_Name=>}Status)/Count({1<File_Name=>}Status)),File_Name)