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.

[JagjeetSingh]

Yes. In Quebec you can make use of function fields. I thought you are on Paris.

So this is how you do it. Use below formula in your report.

glidefunction:add(field_1, field2)

You can add more fields after each comma.

Let me know if this was the correct answer you were looking for.

[CV1]

Hi Jagjeet,

The formula glidefunction:add(field_1, field2) will add 2 fields and return the result as a field value.

My requirement is to sum time worked based on Task and Assigned To for  eg:

please suggest how to do this .

Thanks in advance!

[JagjeetSingh]

Hi,

Sorry to revisit this late but I am here with a solution. 🙂

Create a report with type, Multi-level Pivot.

In columns select Time worked field.

In rows select, assigned to and incident number.

After that use Aggregate function to count distinct Assigned to.

Thats it!

Let me know if this worked.

[CV1]

Hi ,

Thank you for the solution.Will review results with the report users .However I set  

In columns >Task.Company

In rows > Task.Assignedto,Task.Number,Time worked.

 used  Aggregate function to sum  Time worked.

• I wanted to know the difference in data when reporting from

Table : Time worked > time worked

Table :  Task > time worked

I noticed Task>time worked does not show complete data.

Thanks in advance

[JagjeetSingh]

You have a separate table to capture time worked data? I am getting bit confused with your below statement.

Table : Time worked > time worked

Table :  Task > time worked