Missing data columns in report wizard
Hello
I would like to have two different types of reporte for my technicians where they (and I) can easily check which type of tasks they have reported worklog time for in a specific day or week.
For the Module Change I manage to get this two types with the builtin report wizard.
Type 1: Detailed report of all changes with completed worklog time this week
New Custom Report, Tabular Reports, Module Changes
Columns:
Change ID
Title
Change Owner
Time Spent Technician
Time Spent End Date
Time Spent
Date filter: "Time Spent End Date = this week"
Group by: Change owner
Type 2: Summarized report of all time for all changes with completed worklog time this week
New Custom Report, Matrix Reports, Select a module: "Changes"
Summarize top column information by: "Time Spent Technician"
And then the left column by: "Category"
Summarize column by: "Sum of Time Spent"
Filter Options: Date filter "Time Spent End Date: This week"
My problem is that when I try to make a similar report for the Problem and the Request Module, I cannot find the "Total Time Spent", "Time Spent Technician" or "Time Spent End Date". How can I have reports for this Modules similar to the two types of reports I mentioned above?
Our databade is Postgres.
Kind regards Jens Myretyr
I would like to have two different types of reporte for my technicians where they (and I) can easily check which type of tasks they have reported worklog time for in a specific day or week.
For the Module Change I manage to get this two types with the builtin report wizard.
Type 1: Detailed report of all changes with completed worklog time this week
New Custom Report, Tabular Reports, Module Changes
Columns:
Change ID
Title
Change Owner
Time Spent Technician
Time Spent End Date
Time Spent
Date filter: "Time Spent End Date = this week"
Group by: Change owner
Type 2: Summarized report of all time for all changes with completed worklog time this week
New Custom Report, Matrix Reports, Select a module: "Changes"
Summarize top column information by: "Time Spent Technician"
And then the left column by: "Category"
Summarize column by: "Sum of Time Spent"
Filter Options: Date filter "Time Spent End Date: This week"
My problem is that when I try to make a similar report for the Problem and the Request Module, I cannot find the "Total Time Spent", "Time Spent Technician" or "Time Spent End Date". How can I have reports for this Modules similar to the two types of reports I mentioned above?
Our databade is Postgres.
Kind regards Jens Myretyr