4 votes

It would be great to be able to have session times available for reporting purposes. That way we could see which user is spending the most time on for example low productivity sites, or video streaming sites.

The session_minutes table kinda already has this in the schema, although indirectly, through start_time and end_time columns. A calculated column could be added (if PG supports these) that would simply subtract the start from the end time.

I have tried creating a report that extracts the unix epoch from the timestamps and subtracts them, but it didn't work.

If anyone has accomplished this, please let me know

Suggested by: Jacob Degeling Upvoted: 01 Sep, '20 Comments: 0

Under consideration

Add a comment

0 / 1,000

* Your name will be publicly visible

* Your email will be visible only to moderators