# Hours Spent in Sprint Problem **URL:** \ **Category:** Questions & Answers\ **Tags:** sprint\ **Created:** [September 7, 2023, 1:40pm UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674 "2023-09-07T13:40:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![sefa.gerdan](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@sefa.gerdan](https://community.eazybi.com/u/sefa.gerdan)\ **Post date:** [September 7, 2023, 1:40pm UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/1 "2023-09-07T13:40:11Z")
Hello, we have started experiencing some issues in our EazyBI reports as I have described below. Efforts entered for subtasks, especially within sprints, are not reflecting in hours spent. Jira Software 8.22.6 EazyBI Version: 7.0.1 You can see an example of the sprint related to the issues we intentionally created below. There are 3 stories and 2 of these stories have subtasks. Remaining time Estimate: 30h Story Points: 30sp ![image](https://community.eazybi.com/uploads/default/original/2X/0/06e20849fb42331ba2d6b08a60bf83c404b635b2.png) We logged 5 hours of work on subtask TSI-240 under TSI-237. Then, I also logged 7 hours of work on Story TSI-235. ![image](https://community.eazybi.com/uploads/default/original/2X/6/612655bf79b3bd0c6b5768c16e61db990cd76fb4.png) ![image](https://community.eazybi.com/uploads/default/original/2X/3/30b73e3ada18dee0beb100edfc55af73d186d960.png) ```auto { "cube_name": "Issues", "cube_reports": [ { "name": "Anomaly 2 Dashboard", "folder_name": "2. Agile Scrum Reports", "result_view": "gantt_chart", "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Sprint start date]","[Measures].[Sprint end date]","[Measures].[Sprint Status]","[Measures].[Sprint issues committed]","[Measures].[Sprint Story Points committed]","[Measures].[Sprint Remaining Estimates committed]","[Measures].[Hours spent]","[Measures].[Hours spent with sub-tasks]","[Measures].[Issue Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Sprint","selected_set":["[Sprint].[The Shift Initiaitive].[BSSTeamName - Sprint 4]"],"members":[],"bookmarked_members":[]}],"order_by":{"expression":["[Measures].[Sprint end date]"],"order":"DESC"},"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true},{"depth":1,"name":"The Shift Initiative","full_name":"[Project].[The Shift Initiative]","drillable":true,"key":"TSI","parent_full_name":"[Project].[All Projects]"}],"bookmarked_members":[],"current_page_members":["[Project].[The Shift Initiative]"]},{"name":"Sprint","duplicate":true,"selected_set":["[Sprint].[The Shift Initiaitive].[BSSTeamName - Sprint 4]","[Sprint].[Active Sprints]"],"members":[{"depth":0,"name":"Active Sprints","full_name":"[Sprint].[Active Sprints]","calculated":true,"drillable":true,"dimension":"Sprint","expanded":true,"drilled_into":false},{"depth":2,"name":"BSSTeamName - Sprint 4","full_name":"[Sprint].[The Shift Initiaitive].[BSSTeamName - Sprint 4]","url_id":1266,"url_sub_id":276,"parent_full_name":"[Sprint].[Active Sprints]"}],"bookmarked_members":[],"current_page_members":["[Sprint].[The Shift Initiaitive].[BSSTeamName - Sprint 4]"]}],"nonempty_crossjoin":true},"options":{},"view":{"current":"gantt_chart","maximized":false,"gantt_chart":{"left_width":[311.094,1338.2259999999999],"timescale":"weekly"},"table":{"freeze_header":false}},"calculated_members":[]} } ], "calculated_members": [{"dimension":"Measures","name":"Hours spent with sub-tasks","format_string":"#,##0.00","formula":"[Measures].[Hours spent] +\n[Measures].[Sub-tasks hours spent]"},{"name":"Sprint start date","dimension":"Measures","format_string":"mmm dd yyyy","formula":"[Sprint].CurrentHierarchyMember.get('Start date')"},{"name":"Sprint end date","dimension":"Measures","format_string":"mmm dd yyyy","formula":"[Sprint].CurrentHierarchyMember.get('End date')"},{"name":"Sprint Story Points committed","dimension":"Measures","format_string":"#,##0.00","formula":"( [Measures].[Story Points added],\n [Transition Field].[Sprint status],\n [Sprint Status].[Active],\n -- An issue was in a sprint at a sprint start time\n [Issue Sprint Status Change].[Future =\u003e Active]\n)\n"},{"name":"Sprint issues committed","dimension":"Measures","format_string":"#,##0","formula":"( [Measures].[Transitions to],\n [Transition Field].[Sprint status],\n [Sprint Status].[Active],\n -- An issue was in a sprint at a sprint start time\n [Issue Sprint Status Change].[Future =\u003e Active]\n)\n"},{"dimension":"Measures","name":"Issue Hours spent","formula":"[Issue].CurrentHierarchyMember.get('Hours spent')","format_string":"#,##0.00"},{"name":"Active Sprints","dimension":"Sprint","formula":"Aggregate(\n Filter(\n [Sprint].[Sprint].Members,\n NOT [Sprint].CurrentMember.getBoolean('Closed')\n AND\n IIF (IsEmpty([Sprint].CurrentMember.get('Status')),\n NOT isEmpty([Sprint].CurrentMember.get('Start date')) ,\n [Sprint].CurrentMember.get('Status') = \"Active\")\n )\n)\n","format_string":""},{"name":"Sprint Remaining Estimates committed","dimension":"Measures","formula":"-- annotations.group = Time tracking\n( [Measures].[Remaining estimated hours added],\n [Transition Field].[Sprint status],\n [Sprint Status].[Active],\n -- An issue was in a sprint at a sprint start time\n [Issue Sprint Status Change].[Future =\u003e Active]\n)","format_string":""},{"name":"Sprint Status","dimension":"Measures","formula":"[Sprint].CurrentHierarchyMember.Get('Status')","format_string":""}] } ``` but i remove the sprint dimensions in report, the result ![image](https://community.eazybi.com/uploads/default/original/2X/e/e2f006d7e3195ada79c10cfce2701b7cac19cd9a.png) ---
**Author:** ![sefa.gerdan](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@sefa.gerdan](https://community.eazybi.com/u/sefa.gerdan)\ **Post date:** [September 12, 2023, 11:19am UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/2 "2023-09-12T11:19:09Z")
Additional info: [Measures].[Remaining estimated hours with sub-tasks] and [Measures].[Original estimated hours with sub-tasks] measures work well. But the interesting thing is i can not see this measure in eazybi [Sub-tasks remaining estimated hours] , [Sub-tasks original estimated hours] or [Sub-tasks hours spent] i do not understand how can eazybi calculate it. ```auto [Measures].[Hours spent with sub-tasks] = [Measures].[Hours spent] + [Measures].[Sub-tasks hours spent] [Measures].[Original estimated hours with sub-tasks] = [Measures].[Original estimated hours] + [Measures].[Sub-tasks original estimated hours] [Measures].[Remaining estimated hours with sub-tasks] = [Measures].[Remaining estimated hours] + [Measures].[Sub-tasks remaining estimated hours] ``` ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [September 13, 2023, 11:07am UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/3 "2023-09-13T11:07:30Z")
Hi @sefa.gerdan Welcome to eazyBI community. We have seen a similar behavior when hours are logged outside the sprint dates or after issue is removed from the sprint. Could you please share one more the screenshot from your issue-level report with additional columns: “Issue sprint”, “Issue Sprints”, “Sprint issues completed”, “Sprint issues removed”, “Sprint actual end date” Martins / eazyBI support ---
**Author:** ![sefa.gerdan](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@sefa.gerdan](https://community.eazybi.com/u/sefa.gerdan)\ **Post date:** [September 14, 2023, 7:34am UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/4 "2023-09-14T07:34:31Z")
Hi martins, You can find the report below. The timesheet is very critical report in our company, and at this level, it is so critical situation. almost everyday i got a question from our team members. ![image](https://community.eazybi.com/uploads/default/original/2X/9/9bd047e0b8e3db4674f25588551ce1c15e64b9dc.png) ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [September 14, 2023, 9:10am UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/5 "2023-09-14T09:10:23Z")
@sefa.gerdan Please reach out to [support@eazybi.com](mailto:support@eazybi.com) and provide (copied to text file) the JSON results from two following queries (run them in your Jira browser) ```auto http://JIRA_BASE_URL/rest/api/latest/issue/TSI-237?expand=changelog http://JIRA_BASE_URL/rest/api/latest/issue/TSI-235?expand=changelog ``` Don’t forget to update **JIRA\_BASE\_URL** Perhaps some change can be seen which is the reason why hours are not counted correctly to the rithg sprint. Martins / eazyBI ![image](https://community.eazybi.com/uploads/default/original/2X/4/4d151e165c50e04e21835b2b31a0b0a307b854bc.png) ---
**Author:** ![sefa.gerdan](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@sefa.gerdan](https://community.eazybi.com/u/sefa.gerdan)\ **Post date:** [September 14, 2023, 10:14am UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/6 "2023-09-14T10:14:01Z")
Thank you so much. I sent the json files. ---
**Author:** ![sefa.gerdan](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@sefa.gerdan](https://community.eazybi.com/u/sefa.gerdan)\ **Post date:** [September 27, 2023, 3:52pm UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/7 "2023-09-27T15:52:39Z")
thank you so much team. ---
**Author:** ![Maher\_Malak](https://community.eazybi.com/user_avatar/community.eazybi.com/maher_malak/32/10398_2.png) [@Maher\_Malak](https://community.eazybi.com/u/Maher_Malak)\ **Post date:** [August 7, 2024, 2:04pm UTC](https://community.eazybi.com/t/hours-spent-in-sprint-problem/13674/8 "2024-08-07T14:04:14Z")
Hello, @martins.vanags what was the solution please ? Because i am facing a problem with Eazybi that is reporting hours in a ticket that was moved to another sprint. More details : - a ticket with 12hrs spent with a sprint 1 → this sprint ended in 31st of january - the ticket moved to sprint 2 (started beginning of february) - in the EazyBi report, when i filter the hours spent for sprint 2, i see the 12hrs in january thanks Maher