We set up DOMO to pull from our Jira issues. We noticed that the Velocity charts were not matching up. We realized that for issues that are rolled into more than one sprint - if they weren't complete in sprint 1, they will be rolled into sprint 2 - when closed, DOMO will count their point values for velocity against the first sprint in the list, instead of the last.
There doesn't seem to be a clean, consistent way to use JQL to find the sprint an issue transitioned to Done in. And DOMO doesn't appear to have the flexibility to sort sprints by date within an item's metadata.
Has anyone approached this before?