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
