Worklog (Hour Spent) Description Comment

Questions & Answers
1

Hi All,

I’ll try to explain my issue with an example.
I need to create a report that day by day show the number of hours spent during the day (hour spent measure, I know) and the worklog description, that is the is the comment that the user add when it log new hours.

In this image the field I’m talking about:

Then

Row: Issue and Time
Column: Work Log Comment

My biggest problem is:

  1. I don’t know how the create a measure that calculate this comment. How to do it? Is there any custom field to be imported? What is his name?
    Description hosted at ImgBB — ImgBB

Second issue is:
2) Supposing I will be able to solve the issue 1), it can happen that an user log hours more then one time during a single day, then I’ll need to have two rows for one day with the two logs description comments , that is have a time dimension on a hour basis and not daily basis, or…to find a way to have two rows for the same day containing the two comments.

Thanks all.

Tullio.

1 Like
2

Hi, @tulliodisimone

​Use dimensions Tme and Issues in the rows and Hours spent in the columns.
​
​To get the worklog comments, please define a new calculated measure using this formula:
​

Generate(
  Filter(
    [Worklog].[Worklog].Members,
    [Measures].[Hours spent]>0),
    [Worklog].CurrentHierarchyMember.GetString('Comment'),
    CHR(10)
)

​Kind regards,
​Ilze support@eazybi.com
​

1 Like
3

Generate(
Filter(
[Worklog].[Worklog].Members,
[Measures].[Hours spent]>0),
[Worklog].CurrentHierarchyMember.GetString(‘Comment’),
CHR(10)
)

Hi iLze,

thanks. What type of Formatting? Default or Text?
Should I have Worklog dimension on my eazybi in order to apply this measure?

1 Like
4

Hi, @tulliodisimone

Yes, choose Text Plain, and this solution works without the Worklog dimension.

Kind regards,
Ilze support@eazybi.com

1 Like
5

the report takes too much time to load. how can we enhance it?