I know in the Clarity web UI we can see the total time saved on the task servers page but this is a running total from when the system came online. We can also see total time saved for each project on the project pages in the web.
Is there any way to filter time saved numbers by date or by project tags or by type of task? Is this possible in the SQL management studio?
Matt, it's certainly possible with SQL Management Studio or PowerBI or tools like that.
In general, we calculate the saved time for a given task as the [DateCompleted] minus the [StartDate] (filtering down for tasks that actually have a start date, usually by the status = 'Completed').
So for getting the information by date or type of task, you'd have to do that.
In Clarity 2019.1, we also have new tables called:
- TaskScheduleTimeSummary - a summary of time saved by task definition
- TaskTimeSummary - a summary of time saved by project
These are updated once per day, to reduce the load for computing the numbers.
