Tempo Timesheets Work Description

Questions & Answers
1

Is it possible to import the Tempo Timesheets Work Description into EazyBI?

Thanks

2

Hi,

Already now you could see work description for worklogs if you select measure “Hours spent” from “Measures” dimension, click on the result and choose “Drill through worklogs”. It would be possible to export if needed.

Drill%20through%20worklogs
Drill through worklogs.jpg2824×916 294 KB

worklog%20comments
worklog comments.jpg3428×1338 298 KB

But it would also be possible to import Worklog comments as a separate dimension in eazyBI (in this case you should use eazyBI advanced settings to define this additional dimension first)

worklog%20comment%20as%20dimension
worklog comment as dimension.jpg1810×960 165 KB

Martins / eazyBI support

3

Hi @martins.vanags Could you help me create this dimension? Thanks :grinning:

4

@JonathanSantos

Use the following code in eazyBI advanced settings:

[jira.customfield_wlcomment]
name = "Worklog Comment"
data_type = "string"
dimension = true
worklog = true
javascript_code = '''
if (worklog.comment) {
worklog.customfield_wlcomment = worklog.comment+" ("+worklog.id+")";
}
else {
worklog.customfield_wlcomment = "(no comment)"
}
'''

Then open the import options page and select to import “Worklog comment” new pre-calculated custom field as a separate dimension.

Martins / eazyBI

5

@martins.vanags Thanks !!! :clap: :clap:

1 Like
6

I’ve tried out the above solution and it works 
 to a degree 
 but suspect I’m doing or not doing something very obvious to not get the complete solution.

I’ve created the custom measure for Worklog Comments and when I drill down into a work log then the Worklog Comments appear, but when I just try to show the Worklog Comment inline with other data then it doesn’t appear or worse still it hides all data.

tempo-wl-comments-1
tempo-wl-comments-1935×571 28.6 KB

tempo-wl-comments-2
tempo-wl-comments-21844×773 55.1 KB

tempo-wl-comments-3
tempo-wl-comments-31362×789 56.1 KB

tempo-wl-comments-4
tempo-wl-comments-41069×909 43.5 KB

7

@MarkWheeler
It seems that the advanced settings do not let you import “Worklog comments” into a separate dimension using the approach described above.
Which version of eazyBI and Tempo are you using?

Martins / eazyBI support

8

Hi @martins.vanags , I get the same result that @MarkWheeler. I’m ussing eazyby in a cloud instance.

Could you helpp me? Thanks in advance!

9

@Celeste_D_Alessandr1

See the documentation page about this feature:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Calculatedworklogcustomfield

Calculated worklog dimensions work for Jira Server and Data center only, That is why it won’t work in a cloud instance.

Martins / eazyBI

10

Hi Martins, why I can not see this ‘‘Drill through worklogs’’ if I right click on Hour Spent column? How to add this feature to my company eazybi?

Thanks

11

That is a default functionality. It should be automatically available for “Hours spent” measure.
Did you press on the cell value or on the column name?

Martins

12

Yes, I have a long list of ‘‘Drill into’’ options, but not ’drill through worklogs’.

13

@tulliodisimone
Can you share a screenshot from “About” menu where you can see the version of eazyBI?

Martins /eazyBI

about eazyBI
about eazyBI1750×538 144 KB

14

Hi,

yes of course

Thanks

Tullio

15

Thanks.
This version supports “Drill through worklogs” feature.
Do you use it on the default measure “Hours spent” in your report?
Can you please share the screenshot of what you see when you click on “Hours spent” measure in any of the report cells?
Martins

16

Hi,

ok now I can see it.
But I’d like to see the list of worklog comments in a report column. That is, for each day, I’d like to see the daily hour spent + worklog comment.

Is it possible without create a custom dimension?

Thanks

Tullio

17

Hi,
It is not possible to import comments without additional pre-calculated field (defined in advanced settings).
See a similar question discussed here: Worklog comment import

Martins / eazyBI

18

Hi Martin,

thanks

can you confirm only to Jira system administrators, Jira trusted users, and eazyBI admins can access to advanced settings? I’m not one of them

19

Hi,

Yes, advanced settings are not available for all eazyBI users.

If you use eazyBI for Jira Cloud and Tempo timesheets to register worklogs, then worklog comment field import won’t be possible.

Martins / eazyBI

20

Hi, why it won’t be possible ,why it’s possible for jira server and not for jira cloud