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]

Hi,

This error is expected. Creating multi-level pivot reports includes a lot of data to visualize.

Try to put some filters in your report. Like- Created on this month.

OR try increasing the value of property- glide.ui.report.list.published.max_rows (this may have impact on performance)

Mark my response correct or helpful if it worked for you.

[CV1]

Hi,

 Filtering data for this month also is not addressing the issue using pivot or multi pivot. I get an error "Widget cancelled - maximum execution time exceeded"

• Please suggest a better way to represent the report. 
• How to sum/average or perform any calculations on a report column values in a list report.
• How to set default company name in a reference interactive filter? 
• The challenge is i can filter data for one company A , created on this month and view the report.
• I need to display this on a dashboard where the user can select any company from Account interactive filter to view time worked for that company.
• In this case the report  will not render data as company A is set in the filter of the report. If company A is removed from the filter, it gives error "maximum ..."

Thanks in advance

[JagjeetSingh]

Hi,

If you want to go with list report then we can't calculate and show total(possible in Quebec though). You can create a custom field on table to store the total time worked for each incident and create report based on that.

But yes, I'll support the idea to go with default value in interactive filter.

You can set the default value for interactive filter. Go to your filter and add the value in Default Value.

Let me know if this works. Try impersonating with users and see how the filter is behaving for users for the second time they access the dashboard. I am suspecting that the filter will not change to default value after that. Try and let me know.

[CV1]

Hi Jagjeet,

Thank you for the response. I did the default value to the Interactive filter and the report renders  better now using pivot . Impersonated and like you said the filter does not change to default value but shows previously selected value. This is fine as long as the report does not try to get data for all customers and error out . 

I was looking at  Quebec Reports > configure function field with operators like add,coalesce etc. 

any lead on how to calculate Total Duration based on Task,Assignedto and Time Worked using configure function field.

Thanks in advance.