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
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.
{
"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
