Hey everyone,
I’m using JIRA with time-tracking turned on. I need to make a report that shows how much time each person spent on tasks during a specific period. The built-in time report doesn’t cut it for what I need.
Does anyone know if there’s a way to do this with JIRA’s regular features? Or maybe there’s a free add-on that can help? I’ve looked around but can’t find anything that fits the bill.
I’d really appreciate any tips or suggestions. Thanks in advance for your help!
I’ve found a solution that might work for you. JIRA’s ‘Time in Status’ report can be customized to show individual time spent. Navigate to Reports > Time in Status, then select your project and date range. You can filter by assignee to see each person’s time.
For more detailed data, consider using the JIRA REST API. It allows you to extract time tracking information programmatically. You can then process this data in a spreadsheet or custom script to generate the exact report you need.
If you’re comfortable with coding, this approach offers the most flexibility. Otherwise, the ‘Time in Status’ report combined with some manual data manipulation might be your best bet without additional add-ons.
hey there! i’ve been using jira for a while and faced similar issues. have u tried the ‘worklog’ feature? it lets u see individual time entries. you can export this data to excel and make custom reports. might take some fiddling but its worth a shot. good luck!
I’ve dealt with this exact problem before, and I found a workaround that might help you out. JIRA’s built-in reporting can be limiting, but there’s a neat trick using JQL (JIRA Query Language) that can get you the data you need.
Try creating a custom JQL filter that includes the specific time period and users you’re interested in. Then, use the ‘Time Tracking’ gadget on a dashboard, applying this filter. It won’t give you a perfect report, but it’s a good starting point.
For more detailed analysis, I’d recommend exporting the data to a spreadsheet. You can do this by running your JQL query, selecting all issues, and then using the ‘Export’ option. Choose CSV or Excel, and make sure to include the ‘Time Spent’ field.
Once you have the raw data, it’s pretty straightforward to create pivot tables or custom formulas to break down time spent per person. It’s not the most elegant solution, but it gets the job done without needing additional plugins or add-ons.