Is it possible to import the date a worklog was added? We’re trying to track users adding past work. Jira cloud does not send a notification when tempo updates the worklogs, was thinking a list of worklogs by the order they were added, not by the work date, would be useful.
eazyBI can import additional worklog data as a dimension. An other dimension with a date will be of little help to you to pinpoint the worklogs that get created past their starting date.
This will create a new custom field in the eazyBI import settings that you can select for import as a dimension. Once imported, you can find it in the dimension section under the “Worklog” link. Please have a look at a picture of a sample report below:
Robert // eazyBI staff
Thanks @roberts.cacus . I actually want the date. The PMs will want to know which worklogs have been added since they last reviewed the timesheets. The lag without the creation date will not be informative enough. We’d want a table like:
|Issue Key||Date created (Sort by this)||Worklog||Time worked||Date worked|
|ABC-1||2019-03-09||Worked on ABC-1||4h||2019-01-17|
|2019-03-10||Worked on ABC-1||8h||2019-03-10|
Please note that it is possible to import worklog data only as a dimension. The report could look similar to the picture below:
The Time dimension would display the date for which the work was logged; the Worklog created date would display the date in which the hours were added.
Roberts // eazyBI support
You can adjust the calculation of the variable wdate to the one below:
var wdate = ("0" + wd.getDate()).slice(-2)
Roberts // email@example.com
Thanks @roberts.cacus . It worked!