Reports & Dashboards

Build custom reports with tables, charts, pivot tables, and visualisations to analyse project and organisation data.

Report Builder

Accessing Reports

  1. Go to Project > Reports or Organisation > Reports
  2. View existing reports or create new ones
  3. Reports can be project-specific or organisation-wide

Creating a Report

  1. Click Create Report
  2. Enter report details:
    • Name: Report title
    • Description: What the report covers
  3. Add sections to the report
  4. Configure each section's data source and visualisation

Report Sections

Each report contains one or more sections, each with its own data source and display mode.

Data Sources

Sections can pull data from various project modules:

  • Mail register
  • Document register
  • Contract register
  • Inspection records
  • Incident and injury records
  • Observations
  • Submittals
  • Meeting action items
  • Site diary entries
  • And more

Display Modes

List Mode

Display data as a table:

  • Select columns to display
  • Apply filters to narrow results
  • Sort by any column
  • Add charts based on the table data

Summary Mode

Create pivot tables with aggregations:

  • Group data by categories (e.g., by type, status, month)
  • Apply aggregations (count, sum, average)
  • Cross-tabulate data for multi-dimensional analysis

Charts

Add visual representations to any section:

  • Bar charts
  • Line charts
  • Pie charts
  • Stacked charts
  • Configure chart axes and labels

Report Dashboards

Creating a Dashboard

Combine multiple report sections into a visual dashboard:

  1. Create a report with multiple sections
  2. Each section displays as a card on the dashboard
  3. Arrange sections for the best visual layout
  4. Mix tables and charts for comprehensive views

Dashboard Use Cases

  • Project Overview: Key metrics across all modules
  • Safety Dashboard: Inspection results, incidents, observations, and permits
  • Financial Summary: Contract values, claims status, budget utilisation
  • Document Status: Document register statistics and revision tracking
  • Compliance Tracking: Outstanding items, overdue actions, and deadlines

Custom Columns

Calculated Fields

Add custom columns with calculations:

  • Derived values from existing data
  • Conditional formatting
  • Status indicators

Column Configuration

For each column in a report:

  • Show or hide
  • Set column width
  • Apply formatting
  • Set sort order

Data Filtering

Applying Filters

Narrow report data with filters:

  • Date ranges
  • Status values
  • Type categories
  • Assigned users
  • Custom field values

Saved Filters

Save filter configurations for quick access to commonly used views.

Template Reports

Using Templates

Start from pre-built report templates for common use cases:

  • Select a template when creating a new report
  • Customise the template to suit your needs
  • Templates provide a quick starting point for standard reports

Sharing and Export

Sharing Reports

  • Reports are accessible to users with appropriate permissions
  • Share specific reports with team members
  • Dashboard views provide at-a-glance summaries for stakeholders

Exporting Data

Export report data for external use:

  • Download table data
  • Export for use in spreadsheets

Best Practices

  • Start with templates: Use pre-built templates and customise rather than starting from scratch
  • Keep dashboards focused: Create separate dashboards for different audiences (management, safety, commercial)
  • Use charts for trends: Visualise data over time to identify patterns
  • Filter appropriately: Apply filters to focus on actionable data
  • Review regularly: Schedule regular reviews of key reports with your team
  • Use summary mode for analysis: Pivot tables are powerful for understanding data distribution and patterns