Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geeks,
I have been working so long in assigning the rank to one of my column at the modeling level. I have tried the following expression in the straight table and is working perfectly but I want to implement the same in the Backend.
Expression: =aggr(rank(UpTime,4),Hrs,DATE,UpTime,HostName)
please find the below straight table
DATE | Hrs | HostName | UpTime | Rank |
---|---|---|---|---|
27-02-2017 | 00 | A | 0.98 | 2 |
27-02-2017 | 00 | B | 1 | 1-2 |
27-02-2017 | 00 | C | 1 | 1-2 |
27-02-2017 | 00 | D | 0.97 | 3 |
27-02-2017 | 01 | A | 0.98 | 2-2 |
27-02-2017 | 01 | B | 1 | 1 |
27-02-2017 | 01 | C | 0.98 | 2-2 |
27-02-2017 | 02 | A | 0.97 | 2 |
27-02-2017 | 02 | B | 0.98 | 1 |
Kindly help me with the Logic how this can be implemented.
Thanks.
hi
Try this expression:
aggr((rank(UpTime,4),Hrs,DATE,UpTime,HostName),0,1)
So, you would like to see 1-2, and 2-2 as rank from back end scripting also?