Hello
I am trying to have a report that would show logged time and than logged time that was created after the resolution of a issue but it returns nothing can somebody help with this. It would be great if I could be able to filter out logged time that was created after 30 days from resolving the issue.
On rows I have time but I will have users that logged the time so I can see how much logged time they have and how much they log on old issues. 
My measure looks like this:
Sum(
Filter(
Descendants([Worklog].CurrentHierarchyMember, [Worklog].[Worklog]),
NOT IsEmpty([Issue].CurrentHierarchyMember.Get(āResolved atā))
AND
DateCompare(
[Worklog].CurrentHierarchyMember.Get(āCreated atā),
[Issue].CurrentHierarchyMember.Get(āResolved atā)
) > 0
),
[Measures].[Hours spent]
)
Thank you in forward for any help
Hi @Patrik_Stoural,
For such a calculation, you would need to consider each issue individually to retrieve their resolution date and then retrieve the hours spent in periods after that. Seeing the number of issues resolved each month, such a calculation would be heavy.
As an alternative, consider retrieving the amount of work logged in a specific transition status or category. For example, to view the amount of work logged in issues that were in any of the āDoneā status categories, the formula would look similar to the one below:
([Measures].[Hours spent],
[Transition Status.Category].[Done])
Another way would be to calculate this upon data import with JavaScript calculated custom fields. I donāt have such an example on hand. Still, you can take inspiration from an example from our documentation page where updated worklogs are accounted for - Count of updated worklogs by worklog period. Instead of considering the worklog updated date, you could consider the issue resolution date and instead of the ā1ā, return the time spent.
Best,
Roberts // support@eazybi.com
