Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team,
Can you please advise how to achieve RANK output as below with dynamic sorting of KPI as shown
KPI | SORTORDER | formula |
Drop Rates % | Desc | sum(count)/5 |
callcount | Asc | sum(count) |
Master Table with KPI | |||
id | name | Drop Rates % | callcount |
1 | A | 5 | 5 |
2 | B | 5 | 5 |
3 | C | 10 | 10 |
4 | D | 10 | 10 |
5 | E | 2 | 2 |
6 | F | 3 | 3 |
7 | G | 7 | 7 |
8 | H | 1 | 1 |
9 | I | 4 | 4 |
10 | J | 4 | 4 |
11 | k | 4 | 4 |
OUTPUT REUIRED IN STARIGHT TABLE to DISPLAY 5 ROWS:
Id | name | Drop Rate% | Rank |
3 | C | 10 | 1,2 |
4 | D | 10 | 1,2 |
7 | G | 7 | 3 |
1 | A | 5 | 4,5 |
2 | B | 5 | 4,5 |
ID | name | Calls Count | Rank |
8 | H | 1 | 1 |
5 | E | 2 | 2 |
6 | F | 3 | 3 |
9 | I | 4 | 4,6 |
10 | J | 4 | 4,6 |
Dear Tresesco,
One diffrenece I noted. One thing that the requirement output was that for CALLCOUNT Rank output is hsowing 5 records but it ranked till4-6 because next ID also has same value.
As per the output requirement same values should be grouped but numbe rof records to display is controlled by vrank.
Can I get the output as shown above for CALLCOUNT.
name | Calls Count | Rank | |
8 | H | 1 | 1 |
5 | E | 2 | 2 |
6 | F | 3 | 3 |
9 | I | 4 | 4,6 |
10 | J | 4 | 4,6 |