Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to set "Updated Date" as "Work Log" date? How to visualize logged time per month in a bar chart?

Torben Dimter June 29, 2020

Hi everyone, 

 

i would like to create a filter in Jira to set the "Updated date" as the "WorkLog date".

The reason is that i'd like to show my logged time per month in a Jira Dashboard.

Let's say in the "Multiple Filters Bar Chart", i could chose "Created" for the date field. The problem then is that when i create a task e.g. in June but start work on it July, my work log will then appear for June in the bar chart. 

The other option is that i could chose the "Updated date" as date field for my dashboard-gadget. The problem then is that when i put a comment on the ticket e.g. in August after completion of the work in July, the "Updated Date" will change to August. 

Therefore, i thought asout setting the "Updated date" to "Work log date".

 

Any ideas how to solve the problem?

 

Thanks,

Torben 

2 answers

0 votes
Torben Dimter June 30, 2020

Cause on a standard Jira-Dashboard, i have many options for a date field value in charts, but none of them is like "worklogDate"

0 votes
Alexander Eck [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 30, 2020

Torben,

not sure if you are aware but you can use the "worklogDate = ...." function in JQL.

BR

Torben Dimter June 30, 2020

Hello Alexander, 

thanks for answering. 

Sure, but i don't know how. I tried the following: 

worklogDate = updatedDate

to eliminate updated issues after the worklog, e.g. just putting a comment on the issue. 

But this produces an error in Jira because then the format is invalid. 

Regards

Torben Dimter June 30, 2020

Maybe i have asked the wrong question, because my problem is: 

I just want to see the logged work as the latest update for an issue. 

The question would be like:

Can I somehow set the work log date as the "latest update" date?

Alexander Eck [Tempo]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 3, 2020

Torben,

adding a worklog is also updating the Jira issue (and the Dateupdated field).

But maybe you know this already?

BR

Torben Dimter July 6, 2020

Hi Alexander, 

thanks for answering. 

Yes, I know that already and I'm very fine with this.

Actually I'd like to use this for my bar chart visualization, because there I can only select fields as "Updated" or "Created" for date fields. The problem then is that if somebody e.g. puts a comment on a issue after logging the work, this will be the new updated date, so that it's quite hard to assign logged work to the date when the work was actually done because any changes on the issue affect the "updated date". 

BR

Suggest an answer

Log in or Sign up to answer