for example, I have a set of 100 requests where efforts were over 10 days of time. So now I need to the total efforts spent on these 100 requests for the first 2 days and should eliminate the rest of the efforts spent on the other 8 days.
You can do this with our "WorklogPRO" app. It allows you to specify a JQL for issues and start/end times of timesheet period. It will give you total time spent and day by day totals. You can also group by different criteria.
You have two ways of accomplishing this with different, let's call it ergonomic aspects to it.
Using Excel
The first would be without paying for any apps, by creating a search query for your 100 requests. You can then export them to a csv and within excel try to find all worklog entries for the given time span of two days.
→ This gives you your results, but takes quite some time and is relatively error prone. Maybe you can speed things up by creating a macro
Using an App
You can install Timesheet Reports and Gadgets with a trial License to test it out. This will give you a sum for the work logged. You can also assign permissions on who can create reports and its really great, yet a little confusing at the beginning.
→ Quick and nice, but not free. In my opinion fully worth it
I hope this was of help, cheers
Andrej from greenique
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.