Dear eazyBI support team.
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:
[Measures].[Issues resolved]) > 0
Thanks in advance for your help.
and + screenshot of my report without an added custom calculated measure
Try this code
[Measures].[Issues resolved] > 0
Martins / eazyBI team
Thank you for your answer!
Unfortunately, your code shows exactly the same results as my calculated measure
Maybe you have any other ideas on why it shows me empty issues?
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.
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