Need help with inconsistent Date Sorting on Chart: Priority Changes and Line Connections

[agreg]

Hi everyone!

I would like to clarify one point, which concerns the sorting of date and time values. Why do some lines on my chart correctly show the date of the ascending sorting and others not?

I use ascending sorting for one of the lines - in this screenshot on the green line I chose order by ascending:

As you can see, the QI-4946 purple line shows the date of the change in priority of the task to fall, first goes 11 December 2024 and then 3 December 2024, although it should be the other way around.

The situation of QI-4812 is a little more interesting - it first shows correct dates starting from 18 September 2024, then increases to 4 December 2024 and ends on 3 December 2024. Why first goes 4 decab, and then 3 puzzle for me.

This situation occurs if I use order by ascending QI-4863.

Here I have removed any sort and by some mysterious reason for me I have the whole chart and the points do not connect lines for green, red and blue task (only two of them), left only for purple =)

@janis.plume maybe you could help me?
Please explain me how to save lines and at the same time make all their dates ascending?

Best regards,
Agreg

[nauris.malitis]

Hi @agreg

Thanks for the details!

The issue here is that you’re mixing up the Priority dimension with the Time dimension.

As you’ve selected date type values as a measure, it shows up the dates in the Y-axis, however, for the X-axis you have both the quarters from Time dimension and different priorities displayed for each of the quarter.

In this case, the slope of the line is not dictated by the time of the change but rather by the order of the Priority members in the X-axis.

You can see that for QI-4946 issue, it was first in Regular then Major priority, but as these two members are displayed in the order Major | Regular, this makes the line seem to slope in the other direction, when, in reality, it shows the exact change that this issue has had on the Y-axis (time passing on).

You can try using the bar chart with only the Priority selected in the Rows section:

​Best regards,
​Nauris