Ann-MarieHolloway Posted October 2, 2019 Posted October 2, 2019 My apologies for raising this again, I'm sure I've seen it on the forum but have been unable to locate the post. Would someone mind reminding me which measure allows you to report on the number of Activities closed? Many Thanks
Steven Boardman Posted October 2, 2019 Posted October 2, 2019 @Ann-MarieHolloway if you are looking for the right table to report against for tasks (not requests) then this is: h_sys_tasks Assuming you have rights, you should find the schema report under Service Manager, and you can find the table and then the column etc which you can create reports and measures against - perhaps you need h_completed_by from this table to look at who is completing the tasks, and count on h_task_id In Advanced Analytics you could create a SQL group by widget as follows: Or create a measure from that table, include the completed by as a saved column and then you can create a widget looking at the tasks completed by users over time Hope that helps
Ann-MarieHolloway Posted October 4, 2019 Author Posted October 4, 2019 Amazing thank you @Steven Boardman 'h_sys_tasks' is what I was looking for so your response is way more than helpful! Have a great weekend.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now