Could you please tell me what does this statement do exactly in eazybi and what it imports from jira?
“Sum(
{
[Issue Type].[Sub-task]
},
[Measures].[Hours spent]
)”
And how to get the sum of time spent in sub tasks in a specific status?
The formula sums logged time from issues with issue type Sub-task. If you would like to pull in logged time in a specific status, you can use Transition status to access the historical status at the time when the hours spent were logged.
You can use it in the tuple with the measure hours spent. The example below will give you logged time in the status In progress for issues with the type Sub-task:
Sum(
{
[Issue Type].[Sub-task]
},
([Measures].[Hours spent],
[Transition Status].[In Progress]
)
)
Daina / support@eazybi.com
I want to get all time logged in all issue type statuses.
at its start and even after it is closed.
for example:
if a user logs 50 mins in the first time then 30 mins then closed the issue and logged 20 mins then the total should be 1 h. 40 mins.
not only 50 mins