-1

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?

Improve this question

1 Answer 1

Reset to default
0

Haven't used DOMO, but regarding:

There doesn't seem to be a clean, consistent way to use JQL to find the sprint an issue transitioned to Done in.

Can't you just get the 'Resolved' field? It holds the date at which an issue's Resolution was set.

Regarding:

All we want is the last sprint the item was in; we can assume it was closed in that sprint.

You can use the 'Sprint' field, which lists all sprints that issue was in, separated by commas. I don't believe there's a way in JQL to get just the last sprint, but it should be straightforward enough to write a program/macro/excel formula/whatever to split on ',' and get the last one.

Improve this answer
4
  • Perhaps, but we want to know the sprint the item was completed in. We might be able to calculate that from the date, but it would be pretty kludgy. All we want is the last sprint the item was in; we can assume it was closed in that sprint. We're thinking about using the Sprint ID from the XML, again assuming that the highest ID number will be the last sprint it was in.
    – Max Cascone
    Commented Oct 11, 2017 at 16:09
  • yeah, i was hoping there was a built-in way to get the last sprint, rather than having to build something, that then needs maintenance, etc. Also, technically, they're not comma separated, at least in the underlying XML. Each sprint gets its own entry in the Sprint custom field: <customfield id="customfield_10007" key="com.pyxis.greenhopper.jira:gh-sprint"> <customfieldname>Sprint</customfieldname> <customfieldvalues> <customfieldvalue id="162">PD 2017 Q4 S1</customfieldvalue> <customfieldvalue id="167">PD 2017 Q4 S2</customfieldvalue> </customfieldvalues> </customfield>
    – Max Cascone
    Commented Oct 12, 2017 at 15:50
  • @MaxCascone Right. Like I said, haven't used DOMO. They're comma-separated if you use JIRA's JQL issue search. Either way, AFAIK there's no way out of the box to get the last Sprint, sorry.
    – Sarov
    Commented Oct 12, 2017 at 16:34
  • Thanks, at least it's good to know I'm not missing a solution due to ignorance. FWIW, the XML i pasted is from Jira, not Domo.
    – Max Cascone
    Commented Oct 12, 2017 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.