Attendance Report Guide

Overview

This attendance/time report tool provides powerful visibility into how your team is working — not just in terms of presence, but how that time is used (tasks, non-tasks, idle, productive/unproductive). With filters for name/team/email/ID, date range selection, toggles to show/hide metrics, format choices (decimal vs HH:MM:SS) and a shift-only mode, it’s flexible for many use-cases. Use the export option to share and analyse the data. And always ensure definitions align across your organisation so everyone interprets the metrics correctly.

Steps:

• Navigate to Data Visuals.

• Click on Attendance.

• Select Attendance Report.

1. What this report shows

The attendance report provides a detailed view of an individual or team’s working & task-time summary over a selected date range. You’ll see metrics such as:

• Name (or Team / Email / ID)
• Total Working Days
• Actual Working Days
• Expected Actual Time
• Actual Time
• Avg Actual Time
• Actual Time Missed
• Avg Start Time
• Avg End Time
• Task Time
• Avg Task Time
• Non-Task Time
• Avg Non-Task Time
• Idle Time
• Productive Time
• Unproductive Time
• Neutral Time

This allows you to monitor attendance, time utilization and productivity in one consolidated report.

2. How to select the data you want?

a) Choose the person or group

You can filter by:

• Name
• Team
• Email
• ID

Select the person(s) whose attendance/time data you want to view.

b) Choose the date range

Pick the “From” and “To” dates to define the period over which the report will run. The report will aggregate and show metrics for that date-range.

c) Show/Hide Properties Sections

You have the option to show or hide each section/metric in the report. For example, if you don’t want to display “Idle Time” or “Avg End Time”, you can turn those off and they will not appear in the report. This gives you customization so you only see the data relevant to your needs.

d) Choose time-format style

You can choose to display durations and times either as:

• Decimal format (e.g., 7.5 hours)
• HH:MM:SS format (e.g., 07:30:00)

This affects how metrics like Task Time, Idle Time, Actual Time are shown.

e) Shift-only mode

If you toggle “Shifts only”, the report will show only the data that occurred during defined shift-hours. Any time outside the shift will be excluded. This is useful if you want to focus on shift performance only.

3. Metric definitions

Here is what each metric means:

4. Using the report step-by-step

• Navigate to the “Attendance & Time Report” section in your system.
• Select the filter criteria: Name/Team/Email/ID.
• Select the date range (From … To).
• Use toggles to enable/disable the sections you need (Working Days, Actual Time, etc). Only the selected metrics will appear in the report.
• Choose the time format (Decimal or HH:MM:SS).
• If you want to restrict to shift-hours only, turn on “Shifts only”.
• Click Generate (or Run) to display the report.
• Review the data. Ensure the metrics reflect your expectations (e.g., if a section is hidden it won’t show).
• Export the report if needed (see next section).

5. Exporting the data

Once you have generated the report with your filters and toggles:

• You can export the data (commonly as Excel / CSV) for further analysis or sharing.
• The exported file will respect your selected metrics and format (decimal vs HH:MM:SS).
• It will include the selected name/team/email/ID as per your filter.
• Use this exported data for dashboards, payroll review, manager review, etc.

6. Tips & best practices

• Hide unneeded metrics: Only toggle on the sections you really need. This keeps the report clean and focused.
• Choose the correct time format: For readability, HH:MM:SS is good for human review; decimal is better for calculations/spreadsheets.
• Use shift-only mode when relevant: If your staff have defined shifts and you want to measure performance in those hours only, use the “Shifts only” option.
• Check date range: Ensure the date range corresponds to your measurement period (week, month, quarter).
• Export for sharing: Use the export function to share with stakeholders (managers, HR) or for archival.
• Compare average values: Use the average metrics (Avg Actual Time, Avg Task Time, Avg Non-Task Time) to compare across individuals or teams meaningfully.

7. Troubleshooting / FAQs

Q. I don’t see a metric I need.

A. Check your toggles — the metric may be turned off (hidden). Re-enable it via the section toggles.

Q. Time values look wrong (e.g., zeros or missing).

A. Verify the date range includes days when the person worked, and that “Actual Working Days” has non-zero value. If “Shifts only” mode is on, confirm shift data exists.

Q. Exported format is unexpected (decimal vs HH:MM:SS).

A. Ensure you selected the correct time-format earlier before exporting.

Q. What does “Neutral Time” exactly mean?

A. This reflects time that is neither evidently productive nor unproductive — check your organisation’s definition.

8. Summary:

The attendance report is a comprehensive overview of how much time team members (or individuals) were scheduled to work, how much time they actually worked, when they started and ended their shifts, how their time was spent (tasks vs non-tasks vs idle), and whether they met expected working hours. It lets you filter by person, team, email or ID, choose a date range, select exactly which metrics to display, and choose the format (decimal or HH:MM:SS). It also supports showing only shift-period data if needed. In short: this report gives you visibility into presence, productivity, time-utilization and attendance patterns — all in a flexible, exportable format.

Updated on: 31/10/2025