Why does filter where worklogDate() = endOfDay() not work in dashboard gadget?

I am attempting to apply a filter to the workload pie chart dashboard gadget to show me only workload time that was logged for today. Using worklogDate() = endOfDay() would make me think I should be getting the sum of "Time Spent" where the "Date Started" field from the Log Work panel equals today.

When I use the filter worklogDate() = endOfDay(), I see issues that have time logged today, but the instead of only time where the Date Started field equals today, I get the sum of all time on those issues.

How do I craft my JQL filter to give me the results I need (only time logged for today) in the Workload Pie Chart dashboard gadget?

1 answer

0 vote

Hi Lisa,

I have three issues with logged time:

  1. KANCARDS-1: 54 Minutes
  2. FNGME-8: 6 Minutes
  3. AS-1: 25 Minutes

AS-1 has worked logged from yesterday and doesn't show up in a jql search when I use worklogDate = endOfDay().  In addition, the two issues show up in the chart as follows:

Screen Shot 2018-01-24 at 3.53.04 PM.png

As you can see the time is coming from the Logged field under Time Tracking on the right side of the ticket:

Screen Shot 2018-01-24 at 3.54.10 PM.png

Hopefully that clears things up a bit.  If not let me know what you're trying to do and we'll go from there.  If you're not using JIRA's native time tracking let me know what add-on you're using for Time Tracking, e.g. Tempo Timesheets, etc.

Cheers,

Branden

Thanks, Branden, but this does not answer my question. I am attaching a screen grab from today of the widget where I have a subtask with time (1h 15m) logged each for today, yesterday, and the day before. The filter I am using is exactly: worklogDate = endOfDay() AND worklogAuthor in (currentUser()).

You can see in the pic that the total time is 3h 45m, which is the total time allocated to this subtask for all three days. Why would I see all the time logged, regardless of the date it was logged to or the date the worklog was created?Capture.JPG

I am using JIRA's native time tracking, so there should be no complications on that end.

Lisa

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 2 hours ago in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

13 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you