Okay! The mission is simple, get multiple of reports that are mostly handling manually and you need to talk with people to understand in an automated fashion.
This ideally should cover things that we would want to know, like:
- Distribution of Engineers within Projects
- Current Load and what we would want to know as expected.
- Projections.
- And of course! The Reports!
End game would be a platform that allows us to manipulate the data and share it securely… like Airtable… but let’s
JIRA
JIRA Sheets
Columns
Regardless of the size don’t forget to get the following columns:
- System Fields
- Labels
- Project
- Project key
- Epic name
-
Epic link
- Parent
-
Sub-tasks
- Issue URL
- Story Points
- Smart Columns
- Project type *
- Time since first comment
- Date of first comment
- Assignee(s) - Number of values
- History Columns
- Time with assignee
- Number of assignee changes
- Date of status
- Date of status change
- Time since status
- Time since status changed
- Time in status
- Time between statuses
- Resolved date
- Time since resolved
- Time since created
- Time since updated
- Last updated by user
- Last update action
- Number of updates
- Last viewed date
- Create date
- Update date
- Previous Status
You can get a lot from it, specially using the smart columns.
Values that can be useful for metrics and references can be:
- Project
- Project Kek
Airtable and You
You can import data from Jira in excel format, specially if you are including a lot of details.