I need to generate a report on demand that tells me how much time (hours/minutes) we have:
- Budgeted on each/all tasks/projects
- Spent on each/all tasks/projects
- Remaining on each/all tasks/projects
Whilst I can view this information in Jira, I am looking to generate reports/graphs based upon different metrics within the data... I am currently exporting this data to an Excel spreadsheet & spending an enormous amoount of time formatting data ie: some numeric data is exported in a Number format (0.00), whilst other numeric data is exported in a Time format (0:00), which means I need to create a new column with a Number format & rekey the data that is in a time format. Only once the data is in the correct format, I can create calculations for the information I am looking for. Ideally, I can setup a spreadsheet with dynamic links back to the the Jira data & the data in the Excel spreadsheet is already in a Number format to avoid the time consuming task that I have outlined above.
I have tried the dynamic Excel spreadsheet link in Jira & sadly the data is synced in both Number & Time formats...
Any ideas on how to fix this issues, would be greatly appreciated.
