I am using the plot widget to include a profile in my Qgis print composer map atlas output.
It refers to a layer with distance along (a straight) line and depth attributes as well as the geographic coordinates.
When I select scatter plot with lines to join the dots (there is no simple line plot option), while the line is generally plotted in the expected sequence from 0 - 0.5km etc, occasionally it skites backwards and forwards across the plot.
I have three attributes in the table: fid - integer64 - going 0 to 12000 in linear fashion; distance - real - going up linearly slightly more than a meter at a time; and depth - real - undulating like you might expect on a generally quite flat surface.
The table is currently ordered by fid, but any way other than depth - fid, distance, easting, northing, latitute, etc - would all create a linear point by point increment.
I cannot see what reason is making it jump about or any other way to sort it.
Anybody got any ideas what I can do?
I could use another app to make the plots and reference them as images, but it would be far better if this just worked as expected. It is one of these things that colleagues will ask for a thousand miniture changes. I have used the widget a few times before and never notices it happen.
Edit: It only happens when I use the Altas functionality to 'only show features visible in the map'.
If I plot the whole route from start to end it is ok.
It is when the atlas is set to only show (a buffer around) say 2.5 - 3.0 km, not the whole 0 - 12.7 km, that I get the horrible skiting around, when extracting just the points from the layer that are in the 2.5-3 range.