Sprint Tracking -- Rollup by Feature Group

[Jeff Pek]

Hi all –

 

We’ve been looking for a way to get this, but so far haven’t found a way.

Does anyone know of a way, either “live”, or at least via a report, to get a Sprint Tracking report (i.e., progress toward completion for a particular sprint) rolled up by Feature Group?

 

We can see this level of information for an entire project, but not isolated to a sprint.

 

Thanks!

  Jeff

[Hesself]

I can’t answer your question but am interested in which reports you find most useful?

I like the taskboard but can’t print it as a report. Any ideas?
Hessel

 

---

--
You received this message because you are subscribed to the Google Groups "VersionOne-users" group.
To post to this group, send email to versiono...@googlegroups.com.
To unsubscribe from this group, send email to versionone-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/versionone-users?hl=en.

[Joel]

Morning Jeff,
The feature group roadmap report shows how a feature group is being
completed over sprints. Does that answer your question?

Best,
Joel

On Sep 2, 1:32 pm, Jeff Pek <jeff....@autodesk.com> wrote:
> Hi all -

[Jeff Pek]

Yes, thanks, Joel. But it's not what I want. Are you saying there's a no way to track progress *within a sprint* rolled up by feature groups?
Jeff

Best,
Joel

--

[Joel Tosi]

Ahh, within a sprint. This would be achievable using the Analytics package or through the datamart if you have that. Or you could build a report using the API. Are any of those options possible for you?

Joel

[Jeff Pek]

I'm not sure if we have those things; how would I know?
As for building a report using the API -- that seems pretty heavy-handed for something that (IMO) the product should do out-of-the-box.

Thanks for the info!

[Joel Tosi]

If you have the enterprise or ultimate version of VersionOne and you host your system then you have datamart. If you are hosted by VersionOne and you are on the Ultimate version, then you have the Analytics package.

There is a large number of reports we would like to have in V1, but there is always 'one more'. That was the purpose behind datamart and VersionOne - to provide a low entry means for creating reports.

If you have access to either of these and need assistance, please don't hesitate to ask. Also, please do submit your recommendation to IdeaSpace. Since the roadmap is close, perhaps it could be modified in a future release to accommodate that report.

Best,

[Jeff Pek]

Thanks again, Joel.

We have "Enterprise", and host our system. I guess we don't have analytics.
Can you elaborate on how I might do this "through the datamart"?

Thanks,

[Joel Tosi]

Not a problem Jeff.

Since you host your system, you can install the Datamart (assuming you are on a reasonably recent release, say the last year). The datamart is essentially a daily snapshot of the assets in your V1 system, put into a separate database that is designed for reporting. More information (installation, schema, etc) can be found here - http://community.versionone.com/sdk/DetailedDocumentation/Datamart/VersionOne%20Datamart.html

In your scenario, you would use the daily snapshot of the state of all stories (along with estimates, what feature group they belong to, and other information) for every day in your iteration to create a % complete of the feature group within the iteration.

Once you have the datamart up and running, you can right a SQL query against it (or front-end it with a reporting tool of your choice, like business objects) and create reports against it. You can also connect Excel to it.

Again, in your example (and this isn't correct or complete SQL but meant more or less to convey the intent) you could have something like the following:

Select Story.Name, Story.State, FeatureGroup.Name where Story.FeatureGroupID = FeatureGroup.ID and Story.Date between (Iteration.BeginDate, Iteration.EndDate) group by Story.Date

I hope this helps some. Its actually quite a large topic, so if anything isn't clear, please ask more questions.

Best,
Joel

[Jeff Pek]

OK, thanks, Joel. Got it.
I don't know if we'll put in the effort to do it, however. If it's not in the UI, its value is decreased substantially.

Cheers,

[Joel Tosi]

Completely understand Jeff. You might find some value still in the Datamart, it really opens up a large world of possibilities for metrics.

If you could, please do submit your idea for the report to IdeaSpace - https://ideaspace.versionone.com/default

[JasonF]

I would recommend tagging your stories in "Teams". The Team feature
is the best way to have "sub" groupings within a sprint. This allows
you to differentiate, within the UI, sections of your sprint that are
specific to a certain group or set of features. The daily burndown
offers this filter as well.

On Sep 2, 1:32 pm, Jeff Pek <jeff....@autodesk.com> wrote:
> Hi all -
>