Hello
please look at the table:
| ID | X | Y |
|---|
| 1 | 1 | 10 |
| 2 | 2 | 6 |
| 3 | 3 | 16 |
| 4 | 4 | 18 |
| 5 | 5 | 4 |
| 6 | 6 | 8 |
| 7 | 7 | 14 |
| 8 | 8 | 12 |
| 9 | | 20 |
| 10 | | 2 |
First i want to order the table by X and then define border for the bottom 25%, the halfway 50% border and the 75% border
Second i want to order the table by Y and again define these border values.
so i want to get three values for X and three for Y:
x25=2.25
x50=4.5
x75=6.75
y25=5.5
y50=11
y75=16.5
how can i derive these values in the script?
Later on i can use these borders in for instance a gauge meter object.
your help would be much appreciated
best regards,
Peter
