---
search:
  tags:
    - insights
    - GET
seo:
  description: >-
    What are Project Insights? Project Insights provides detailed analysis…
    Reference for the GET /insights/project-chart endpoint in the Leadtime
    Public API API.
sidebar:
  badge: GET
  label: Get project insights data in structured JSON format
title: Get project insights data in structured JSON format
type: openapi-operation
---
**What are Project Insights?**
Project Insights provides detailed analysis of working hours spent on company projects over time. This endpoint returns data that can be visualized as charts or exported to Excel, showing how time is allocated across projects, team members, task types, and individual tasks.

**What data is returned:**
The response includes two "sheets" of data in JSON format (matching the Excel export structure):
- **Summary sheet**: Wide format (pivot table style) with periods as rows and breakdown categories as columns. Perfect for quick overview and visual chart generation.
- **Detailed sheet**: Long format (normalized/tidy data) with one row per period/breakdown combination. Ideal for further analysis, pivot tables, and BI tools.

**Supported analysis options:**
- **Project selection**: Analyze single project or compare multiple projects side-by-side
- **Date range**: Auto-calculated from time log data if not provided, or specify custom range
- **Model selection**: 
  - timeSeries: Shows data over time periods (trends and comparisons)
  - total: Shows aggregated totals across entire period (distribution analysis)
- **Period granularity**: Group data by months or weeks
- **Breakdown options**: 
  - none: No breakdown (total hours only)
  - byUser: Breakdown by team member
  - byTaskType: Breakdown by task category
  - byTask: Breakdown by individual task
  - byProject: Breakdown by project (only for multiple projects)
- **View style** (single project time series only):
  - trend: Cumulative values showing progress over time (ladder-style bars)
  - periodComparison: Period-by-period values (non-cumulative bars)
- **Display style** (multiple projects time series only):
  - groups: Separate lines/bars for each project (comparison view)
  - stacks: Stacked bars showing combined effort (aggregate view)

**Data structure:**
- Headers and titles are fully localized based on user's language preference
- All entity names (users, projects, tasks) are human-readable (never UUIDs)
- Numeric values include proper formatting (2 decimal places)
- Metadata includes query execution time and data processing statistics

**Use cases:**
- Generate visual charts showing project time allocation trends
- Export to Excel for detailed analysis and reporting
- Track team member contributions over time
- Analyze task type distribution across projects
- Monitor project progress against budgets and estimates

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