Ranges incorrect when completed dates aren't sorted.
Closed this issue · 1 comments
It looks like the way the ranges are calculated (e.g. the completed date range) assumes that any items completed are in the top rows. i just imported some data and it initially showed no cycle time data because all my completed items were at the bottom.
I couldn't repro this with the latest release 1.62. I think it may have been fixed with issue 18 and the issue where indirect formula was failing in some cases where cells "looked" blank but had returned not empty to formula.
I double checked most axis range calculations, and they seem immune to the sort order based on the aggregation using the range from Min to Max of the entire column ranges.
I'm going to close this issue at this time until it get re-reported with an explicit use case.