Total issue time spent for only issues resolved in selected month

Questions & Answers
1

Dear eazyBI support team.

Please advise:
I’m struggling with a case - I need to calculate the total issue time spent for only issues resolved in the selected month.
I have defined a custom calculated measure and it calculates exactly what I need. But when I add this measure to my report it shows me tasks that have logged spent time in the selected period but weren’t resolved at this period, - so they are empty.
Please advise, how can I exclude these empty fields and tasks as well from my report (marked in red on a screenshot) ?

This is my calculated measure:
SUM(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember) AND
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues resolved]) > 0
),
(([Measures].[Hours spent],
[Issue].CurrentMember,
[Time].DefaultMember))
)

with time spent
with time spent1508×594 42.1 KB

Thanks in advance for your help.

Best regards,
Aleksandra

2

and + screenshot of my report without an added custom calculated measure

without time spent
without time spent1500×366 28.2 KB

3

Hi @Aleksandra_Filippova

Try this code

SUM(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember) 
AND
[Measures].[Issues resolved] > 0
),
([Measures].[Hours spent],
[Time].Currenthierarchy.DefaultMember)
)

Martins / eazyBI team

4

Hi @martins.vanags,
Thank you for your answer!
Unfortunately, your code shows exactly the same results as my calculated measure :frowning:
Maybe you have any other ideas on why it shows me empty issues?

5

Hi,

I misunderstood the requirement, you don’t want changes in your calculation but not to show issues that were not resolved in the selected time period.

For that, you can simply filter the report rows by measure “Issues resolved” (Issues resolved > 0)

Your report shows by deafult all issues because you have selected also some properties (like “Issue priority”, “Issu resolution date” etc), which are shown for all issues in the given report context.

Martins

1 Like
6

@martins.vanags
Brilliant solution, it’s exactly what I needed!
Thank you very much for your help and prompt replies!!
And shame on me, it was so obvious :woman_facepalming: