I have a problem, and I’ve looked for a lot of solutions and found nothing.
I need to list the total hours logged in the issues of a given Sprint, but I need to know only the hours that were logged between the day of the Start Sprint and the Closing day of the Sprint.
Sprint 09 - Start Date = 3/15/2020 | End Date = 03/30/2020
Sprint 10 - Start Date = 01/04/2020 | End Date = 4/14/2020
Example
Story A - 10 hours logged on 16/03/2020
Story A - 5 hours logged on 02/04/2020
Story B - 10 hours logged on 29/03/2020
Story B - 3 hours logged on 11/04/2020
On my dashboard, I need to list the sum of all hours logged in the sprint as follows:
Sprint 09 | 20 hours
Sprint 10 | 9 hours
Below is a real example.
I have 3 Issues in my “Sample Sprint 2” Sprint with a total of 22 logged hours
Below is the date of each time log of my Sprint Issues. Note that the Log highlighted in Red (10 hours), was made outside the period of my Sprint, so my measure should not return these 10 hours.
Hi @lincoln19922,
I will start with your first example that I tried to reproduce but with the scenario you provided it looks that Hours spent together with Sprint works exactly as you would expect it.
Here is an example where I used precisely the date you mentioned and when the hours were logged.
In the second example, it looks that the issue was already added to the Sprint when hours were logged, and only after that, the Sprint was started. In this case, hours are counted into the Sprint and you need to create a calculated measure in Measure dimension that you already mentioned above. Tested with my example and it works like a charm where the measure Hours spent within the Sprint takes into account only hours logged after Sprint start date.
Could you please share more information about what exactly didn’t work for you?
There is one similar thread about hours spent in another community question, maybe solution provided there could be useful for your case: