Time worked report

[CV1]

Hi Everyone,

Please guide me on how to create a report to :

• Show time worked by assigned to for an account by Asset,Product,Contract.
• How to sum time worked for a particular task.

• I created a report using Table : Time Worked

and an interactive filter to list the company on the dashboard. When  a company is selected, it display the tasks for the selected company and time worked.

The results displayed have multiple values for the same task(for eg INC109291 has 4 values for time worked ). How  to sum and show as 1 row for a task (INC109291) instead of n rows for a task.

I tried using multi pivot report for this requirement by setting rows  > Task.Case[incident].Number , Task.Case[incident].Time worked

Column > Task.Case[incident.contact , Task.Case[incident]Assigned to. But this takes a very long time to load and if i give a company in report filter , then i cannot choose company from interactive filter on the dashboard.

  Please advise how to create the report to show  account and time worked by a users/assigned to for a task/ticket.

Thanks in advance.

[CV1]

Hi Jagjeet,

I wanted to know significance of  the field "Time worked" mean in these 2 tables.

Table Tasks : 

Table Time Worked:

[JagjeetSingh]

The values of "time worked" fields are stored and are accessible from Time worked table only. 

If you see, the values are empty for "time worked" field on task table.

The purpose is same. Just the value on task table is not populated OOB. you can populate through BRs.

I'd suggest you to dot walk to get the value as it is already available and no additional changes are required.

[Andrew_TND]

Hi, I answered a similar question to this on,

https://community.servicenow.com/community?id=community_question&sys_id=19a82a7fdb6f6490b1b102d5ca96...

In terms of the account dot walk from the task level to the task type in the filtering.

Please mark as helpful or if its resolved the issue, correct!