Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I've a table like this:
Table:
id,user, type, status
1, luis, 2, D
2, john, 3, D
3, jose, 4, S
4, luis, 4, S
I' need to rank this table with a calculated dimension, that is I need to get the top 2 users whith type = {2, 3} and status = 'D'
I create a calculated dimension like this;:
=IF(Aggr(rank(Count({<type={2,3}, status= {D}>} id)),user)<=2, user)
but it doesn' seem to work. The first part, type={2,3} works all right, but the second part whith the field status doesn't. What am I doing wrong?
Tks,
Luis
Hello Luis,
I think that your calculate dimension is correct, it return luis and john that have type 2 and 3 and status D.
Explain why about you the second part whith the field status doesn't work.
Regards
Luca
Hi Luca,
Table:
Load * inline [
id,user, type, status
1, luis, 2, D
2, john, 3, D
3, jose, 3, S
4, luis, 3, S
5, luis, 3, D
6, luis, 4, D
];