Reports
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi all,
I need to create a pivot table for release state moves to closed from june to till today. There is specific field is there to mention the group by field in my release table. My version is Zurich.
Thanks,
Shireesha
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
any screenshot what you looking for ?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi @MShireesha ,
You can do this with a standard Pivot Table report:
- Go to Reports > Create New.
- Source type: Table. Choose your release table (check which one your instance uses, for example the Agile release table or the Release Management one).
- Type: Pivot Table.
- Set the conditions:
- State is Closed
- Closed (closed date) is between 01 June and today
- Configure the pivot:
- Rows: the field you want to group by (for example Assignment group, Product or Assigned to)
- Columns: Closed date grouped by month, or another field such as Type, if you want a second dimension
- Aggregation: Count
- Save it, and add it to a dashboard if needed.
If your release table doesn't have a Closed date field populated, you have two alternatives:
- Use Updated as the date filter. This is less accurate, because any later update changes it.
- Create a Metric Definition on the State field and report on metric_instance. Note that metrics only record from the point they're created, so they won't backfill June data.
If you share a screenshot of the release form and say which field you want to group by, I can be more specific.
Hope this helps.