Forum Discussion
graphic representation
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
- lbendlin
d) assumes that the latest data point is the highest. That assumption fails for ID 900 and Month 24, for example.
Might be better to just add a trend line.
for c) I would use small multiples