Is there a way to use currentUser() in Jira Structure "Work Logged" calculation?

[Manol Krastev]

Hello all,

Hopefully, you can help me out with this, as I'm really close to giving up the smart way of doing things. :D

I've built a structure that inserts all issues where the worklogAuthor = currentUser() and there's some grouping in place, however, the latter does not seem related to the case here, so I'll omit the details. 

Then in the columns of this very same structure, I'd like to see what is the cumulative amount of time that has been spent on the issues that show up. There are four columns that are currently in place - current week, last week, current month, & last month. Unfortunately, I cannot filter by currentUser() in the Logged By field of the columns with the Work Logged type.

The result of all this is that for each backlog item where more than one person has tracked the time spent on it for the specified period the structure will show the sum of hours of all persons.

For example: John has spent 2 hours on ITEM-99 last week and I have spent 3 hours on this very same BLI last week as well. The Structure in question will show 5 hours of total time spent. 

This is what I'd like to avoid. I need to have data shown only for the currentUser() that logged time on the respective BLIs. In case anybody comes up with a solution here, I'll be more than grateful!!!

NOTE: For good or bad, the organization I'm part of is not really willing to use any 3rd party features (plug-ins/add-ons), hence my struggle here. I know that there are aftermarket solutions but can't benefit from them right now.

Thank you forward for your expertise and help with my inquiry! :)

Regards,
Mani

[David Niro]

Hello @Manol Krastev ,

Welcome to the Community!

Please reach out to our support team directly via email support@almworks.com or customer portal support.almworks.com.

We may need to ask for screenshots to help understand your set up.  Look forward to hearing from you.

Best,
David

[Manol Krastev]

Thanks @David Niro , I believe I figured it out. The formula below solved the case. It might not be the most optimized one but it works for now. :)

Formula:
worklogs.FILTER($.author = ME()).MAP(w -> w.timeSpent).REDUCE((a, b) -> a + b)/3600000)

Regards,

Mani