Help with a report - task_time_worked , drillable only over 10 Entries
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi All,
I am after creating the following report but have not been successful.
A single (drillable) real-time count showing all tickets in an active state (excluding resolved) that have 10 or more time entries (by the same engineer)
This is on the task_time_worked table & the report is to show only tasks where 10 or more time entries have been entered by the same engineer.
I have tried with a database view, using related conditions on the report from the task table and the other way round. Online it mentions using aggregate or count options to filter but every way I try I dont have these options. I am sure there is a simple way to do this. Any ideas please ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
For the '10 or more' it would be easy, because related list conditions can help there. But you can't query within those to see how many times they were from the same user. I don't think there is a simple way to do this.
What is the business requirement behind it?
If it's just for control, you can create a list view and do a group by on task and a sort group option of 'count descending' so the task with the most entries is on top. If you add a 'sort by' on user, you will see the people creating the most timecards.
Or a bar chart by 'user', stacked by task.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark