The issue is sometimes you have negative leadtimes (e.g. something is going to happen in the future, not the past), but the display does not show a negative time or other indicator, which results in the values in the column appearing unsorted to users.
The sorting is correct, the first item is the smallest as it’s actually 10 hours and 28 minutes into the future (-10h 28m), but this just looks like the sorting is broken to most users. Is there a way to change this please?
The built-in duration formatter drops the minus sign.
You can try one of these workarounds for a quick fix:
Pre-format a string property. In your pipeline or transform, add a string property such as "-1h 30m" or "1h 30m overdue" and display that. Keep the numeric property for sorting and filtering.
Store the sign separately. Keep the duration as an absolute value and add a direction property (or a boolean). Show the two side by side.
Use conditional formatting. On the property, set up a rule like “value < 0 → red”. The number still shows without a sign, but negative values stand out.
Thanks for the reply. In terms of user friendliness the last option is probably the best, the first removes the ability to aggregate the durations, and the second one is more confusing for users when the want to sort and filter a table.
Hopefully the native ability to show the -ve sign will still be added to the formatting.
