Jump to content

How to measure Activities


Ann-MarieHolloway

Recommended Posts

@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

Link to comment
Share on other sites

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...