Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help with this Rank situation (Aggr with Dimensions) and it must be made on Script (Not in set analysis).
Situation:
Platform | Site | Value |
Mobile | EN | 100 |
Mobile | IL | 300 |
Mobile | DE | 150 |
PC | EN | 200 |
PC | IL | 400 |
PC | DE | 600 |
Crypto | EN | 400 |
Crypto | IL | 300 |
Crypto | DE | 100 |
Wanted Result:
Platform | Site | Value | Rank |
Mobile | EN | 100 | 3 |
Mobile | IL | 300 | 1 |
Mobile | DE | 150 | 2 |
PC | EN | 200 | 3 |
PC | IL | 400 | 2 |
PC | DE | 600 | 1 |
Crypto | EN | 400 | 1 |
Crypto | IL | 300 | 2 |
Crypto | DE | 100 | 3 |
Geat Thanks!!!
Hi Sunny,
Could you please explain how adding 1 and 2 make this work? what is this identifier?
I think the autonumber returns a unique integer value for each distinct evaluated value for entire script execution.So for the second and third time,it can encounter a similar value as the previous one. To make it different counter instances we can add something(here 1 and 2 ) to make it distinct