Hi,
I have the need to visualize the best value of a field on a specific dimension and also I need to visualize 'all other values' that are not included in the previous list.
I try to explain through an example.
I have the following data:
F1 | F2 | F3 | F4 |
---|
A | pippo | 2 | 1 |
A | pluto | 4 | 2 |
A | pap | 6 | 3 |
B | cip | 2 | 4 |
B | paperone | 4 | 6 |
B | pippo | 7 | 4 |
B | pluto | 11 | 5 |
C | pippo | 1 | 8 |
C | minni | 3 | 6 |
C | pluto | 4 | 7 |
C |
| 5 | 2 |
C | ciop | 5 | 5 |
I need to have the best value of F2 according to the value of F4, like below:
F1 | FirstSortedValue({$<F2-={""}>}distinct F2,F4) |
---|
A | pippo |
B | pippo |
C | ciop |
I need to visualize a fourth value for F1 ('Other') that contain all values of F2 except for the values already listed.
The result should be the following:
F1 | FirstSortedValue({$<F2-={""}>}distinct F2,F4) |
A | pippo |
B | pippo |
C | ciop |
Other | pluto |
pap |
cip |
paperone |
minni |
Any suggestion?
Thanks very much in advance.
Davide