---
search:
  tags:
    - insights
    - GET
seo:
  description: >-
    What are Workload Insights? Workload Insights provides detailed… Reference
    for the GET /insights/workload-chart endpoint in the Leadtime Public API
    API.
sidebar:
  badge: GET
  label: Get workload insights data in structured JSON format
title: Get workload insights data in structured JSON format
type: openapi-operation
---
**What are Workload Insights?**
Workload Insights provides detailed analysis of open task volumes across projects and categories over time. Unlike Project Insights which focuses on completed work (time spent), Workload Insights examines the number of open tickets to answer forward-looking questions: "How much work is still in the system?" and "Is demand for services increasing or decreasing?"

**What data is returned:**
The response includes two "sheets" of data in JSON format (matching the Excel export structure):
- **Summary sheet**: Simple format with Period Label and Task Count columns. Quick overview of task volumes.
- **Detailed sheet**: Long format (normalized) with one row per period/breakdown combination. Perfect for detailed analysis and pivot tables.

**Supported analysis options:**
- **Project selection**: Analyze single project or compare multiple projects
- **Date range**: Required for OVER_TIME model, not used for TODAY model
- **Model selection**: 
  - TODAY: Current snapshot of open tasks (similar to dashboard overview). Shows current state without time dimension.
  - OVER_TIME: Historical trend analysis showing how workload has changed over time. Helps identify if more work is coming in than being processed.
- **Period granularity**: Required for OVER_TIME model - group by months or weeks
- **Breakdown options**: 
  - byProject: Task count breakdown by project
  - byTaskType: Task count breakdown by task category
  - byStatus: Task count breakdown by current status (New, In Progress, Feedback, etc.)
  - byAge: Task count breakdown by age groups (how long tasks have been open)

**What counts as "open" tasks:**
A task is considered "open" when its status type is NOT Closed. This includes:
- New tasks
- Tasks In Progress
- Tasks awaiting Feedback
- Tasks in Backlog
- Resolved tasks (not yet closed)

Only tasks with status type Closed are excluded from the analysis.

**Use cases:**
- Monitor current workload across projects
- Track workload trends over time to identify bottlenecks
- Analyze task distribution by type, status, or age
- Compare workload across multiple projects
- Identify if demand is increasing faster than capacity
- Export to Excel for capacity planning and resource allocation

**Business value:**
Workload Insights helps managers:
- Understand current capacity utilization
- Identify projects with excessive backlogs
- Plan resource allocation based on workload trends
- Detect early warning signs of capacity issues
- Make data-driven decisions about hiring or project prioritization

<Operation source="api-reference" id="insightscontroller-getworkloadchart" />