Is there a good way to graph hours logged by CurrentUser() to all projects for an arbitrary period?

[Some Guy]

Hi friends - my team has to log hours to specific projects in Jira for those hours to be visible on managements' dashboards.  We also have to log those same hours in our time cards so that they get deducted correctly from their respective banks.  Each Jira logged to our team has a field called "Project Number" in which the number is meant to be entered; sometimes it's left blank (e.g. for support tickets that don't have a formal bank of their own) or listed as "n/a" (e.g. if the PN hasn't been assigned yet but the project's a-comin' and they want to get the ticket assigned).  It is fairly common for us to log time on multiple Jiras to the same PN, as we have a couple of "catch-all" numbers that we use for the aforementioned support tickets, admin overhead, etc.

It would be super helpful for us to be able to have a filter or a widget configuration that just shows each unique PN - not each unique ticket - that the currentUser() has logged time to in the current time period (I'd prefer "this week" but I know that's probably not going to happen), and the total number of hours logged - something like

• PN 12345 - 6.5 hours
• PN 23456 - 17.2 hours
• PN 34567 - 16.3 hours

....is what I see in my head, but honestly a bar graph would be fine, a table would be great, hell, I'd take a line graph if nothing else came up.

Of note: I don't have the ability to get new widgets added, to modify the server config in any way, or to do anything besides work with what I assume is the default setup.  If there's a way to export the relevant info and feed it to a third party app that doesn't risk leaking proprietary information, I'd be open to that as well - really just looking for anything better than having to try to cross-reference by running through a filter like

worklogAuthor = currentUser() AND worklogDate >= "2023/9/18" AND worklogDate <= "2023/9/22"

every week.

Thanks in advance!

[Fabian Lim]

Hi @Some Guy

Welcome to the community!

I would recommend a reporting plugin such as eazyBI that will pick exactly what you are looking for.  Example: https://eazybi.com/accounts/1000/dashboards/27385-time-tracking

Other plugins may be able to pick it up to.  

[Some Guy]

So that's a "no" to native handling then?  As I mentioned, I don't have any ability to update the configuration of the server, so a plug-in is basically a nonstarter. :-\