Berqun
Reports

How to Get the Office Activity Report?

The Office Activity report lists the activities your staff spent the most time on in the selected period. Activities are sorted by total time, longest first, and the Excel file shows each activity’s time day by day.

Office Activity Excel report

Getting the report

  1. Open Reports > Office Activity in the left menu.
  2. Under Report Period, choose Daily, Weekly, Monthly or Custom and set the period. A custom range can be at most 30 days.
  3. In the Team field, pick the teams you want. If you leave it empty, everyone is included.
  4. Set the Report Options.
  5. Click Export Excel.

Report options

  • BQ Score Calculation: All day (24 hours) or Working hours only.
  • Include both current and archived staff records in the report result. adds staff who are no longer tracked, such as people who have left.
  • Show Activity Types: choose whether the list includes Productive activities, Distracting activities or both. At least one must stay ticked.

Number of Activities sets how many activities are listed: 100, 200, 300, 500 or 1000. Minimum Total Duration leaves out activities whose total time in the period is no more than the minutes you pick. With Highlight Activity Duration you enter a number of minutes and choose Greater than or Less than; day cells that match are coloured in the Excel file. Tick Only list activities with a highlighted day to keep only those activities.

To get the report regularly, use Schedule This Report in the Report Summary card.

You may also be interested in: Staff Activity Report

All Categories