Forum Discussion

schneid's avatar
5 years ago

about Total Person Time vs Total Reviewer Time

I'm answering a question I found on a previous closed thread Collaborator forum: Total Person Time vs. Total Reviewer Time because I was looking for the answer too.


Total Reviewer Time is a subset of the Total Person Time. I think it counts the total time spent by reviewers who actually approved the document. You can test this by summing the Person-Hours for each person with State=Approved and compare to the Total Reviewer Time.


1 Reply

  • aqAnt's avatar
    SmartBear Alumni (Retired)

    Hi schneid,


    Your assumption is correct.


    The Total Reviewer Time metric can explicitly be calculated by querying the activity table of Collaborator.


    In the table, each row represents a slice of time where the user was active. There can be many slices for a given user in a single review. Each slice includes duration (in seconds) and "start time" that is encoded both as database date/time (activity_startdate) and a number of seconds since 1970-01-01 00:00:00 GMT (activity_startsecs). The activity_code column of the table tells whether the user was acting in the capacity of an author (A), reviewer (R), or was doing rework (F) as opposed to actually reviewing. Also, there is a code for when someone views the review but is not a participant (P).


    Thus, the metric is a sum of all the durations of each reviewer activity (R) associated with a given review.