Jump to content

Recommended Posts

Posted

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

Posted

@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

image.png

In Advanced Analytics you could create a SQL group by widget as follows:

image.png

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 

image.png

Hope that helps

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...