Forum Discussion
graphic representation
Good morning,
I would like to represent this graph.
a) evolution of the distance compared to the month
b) draw the line from zero to the maximum distance
c) if I select two identifiers which do not have the same max distance, a message is displayed saying "the two identifiers do not have the same max distance", in this case only the curves will be displayed and not the straight line
example: for a selected ID I would see the evolution of the distance and the line with the initial point up to the max distance,
Thank you for your help
| ID | distance | distance_max | month | test_1 |
| 125 | 12000 | 12 | 25 | |
| 125 | 15000 | 24 | 56 | |
| 125 | 17000 | 36 | 87 | |
| 125 | 18000 | 48 | 95 | |
| 125 | 20000 | 80000 | 60 | 108 |
| 140 | 13000 | 12 | 78 | |
| 140 | 14000 | 24 | 145 | |
| 140 | 17000 | 36 | 189 | |
| 140 | 22000 | 48 | 197 | |
| 140 | 25000 | 100000 | 60 | 200 |
| 870 | 12000 | 12 | 78 | |
| 870 | 11000 | 24 | 89 | |
| 870 | 15000 | 36 | 98 | |
| 870 | 21000 | 48 | 102 | |
| 870 | 25000 | 150000 | 60 | 120 |
| 145 | 12000 | 12 | 145 | |
| 145 | 13000 | 24 | 160 | |
| 145 | 17000 | 36 | 170 | |
| 145 | 18000 | 48 | 180 | |
| 145 | 22000 | 80000 | 60 | 200 |
| 170 | 12000 | 12 | 48 | |
| 170 | 13000 | 24 | 79 | |
| 170 | 17000 | 36 | 85 | |
| 170 | 18000 | 48 | 98 | |
| 170 | 22000 | 60 | 145 | |
| 170 | 24000 | 91000 | 72 | 170 |
| 180 | 12000 | 12 | 48 | |
| 180 | 13000 | 24 | 79 | |
| 180 | 17000 | 36 | 85 | |
| 180 | 18000 | 48 | 98 | |
| 180 | 22000 | 60 | 145 | |
| 180 | 24000 | 20000 | 72 | 170 |
Super Userhere is how your data plots at the moment. Please indicate which changes you require.
Should they all start at (0,0) ?
hi lbendlin thank you for your feedback, I want to draw a line which starts from 0 up to the maximum value for each ID, like that as soon as I select an ID I must see its curve which turns around the line, if the curve is above the right it is a red color, if the curve is below it is green
- lbendlin
Sorry, I am not following. Can you guarantee that the values for each line always increase? One line has more data points than the others - does that matter?
as soon as I select an ID I must see its curve which turns around the lineI cannot visualize that - can you please explain?
ID test_A test_max test_M 125 0 0 0 125 10000 15000 12 125 20000 25000 24 125 30000 35000 36 140 0 0 0 140 14000 10000 12 140 20000 25000 24 870 0 0 0 870 10000 15000 12 870 12000 25000 24 870 14000 30000 36 870 15000 32000 48 900 0 0 0 900 12000 24000 12 900 13000 22000 24 900 14000 35000 36 a)
draw the curvesb) tracer la ligne droite qui part de 0 et va jusqu'à la valeur maximale de test_max
ex : si dans mon filtre id je selectionne un ID je dois voir la corbe de test_A et la droite qui part de 0 jusqu'a la valeur maximale de Test_maxc) if I select two different IDs which do not have the same identical line, a message is displayed "not compatible", in this case the line is not displayed and only the curves which are displayed
ex: ID 125 and ID 900 have the same maximum value 35000 so I will see the curve and the straight line, on the other hand ID 125 and 140 do not have the same maximum value, in this case I select these two, I would not have the right and a message "not compatible is displayed" and only the curves will also be displayedd)put a color if my curve is above the line it's red, if it's below it's green
THanks