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.
