Skip to main content
Loading...
Report Agent
Report Agent
Report Agent

Report Agent

Intelligent reporting assistant that generates custom reports from natural language queries with rich visualizations.

Overview

Report Agent turns a plain-English question into a real report. Ask “headcount by department this quarter” in the Ask AI chat and the agent picks the data domain, builds and validates the query, retrying itself when the first attempt doesn't validate, and answers with a table and an auto-selected chart. Say “filter for active only” or “group by location instead” and it refines that same report rather than starting over. Six agent tools cover the loop end to end: generate a report, refine it, export it, browse report templates, open any report's details, and pull the reports run most recently. Prefer to click? The visual builder lets you pick columns, metrics, grouping and filters by hand, suggests columns from a written description, auto-populates filter dropdowns from your own data, and previews the result live before you save. Save a report under a name, favorite it, duplicate it, and set its visibility to private, shared with named teammates, or public to everyone who can open its data source. Put any saved report on a daily, weekly, monthly or quarterly schedule delivered by email, POSTed to a webhook, or generated for download — in CSV, Excel, PDF or JSON, with each format separately switchable by an admin. Reporting spans around fifty native Workforce data domains (seven of them admin opt-in), each with its own on/off toggle, so an administrator decides exactly what is reportable; managers reach only the team-scoped domains, bounded to their own team or locations, and each of those has its own switch for managers. Admins also get a Usage Analytics tab inside the app: Ask AI turns, people asking, the completed rate with its sample size, runs and outcomes by domain, and the most-asked questions. On a phone, people browse, open, re-run and favorite saved reports and run, disable or enable a schedule — reports are authored on the desktop app.

Ask a workforce question in plain English and get a custom report — refine it conversationally, schedule recurring email or webhook delivery, and export to CSV, Excel, PDF, or JSON.

Highlights

Generate custom workforce reports from plain-English questions in the Ask AI chat — no SQL required.
Build cross-entity reports visually with an AI-assisted column picker and live preview.
Refine any report conversationally — add filters, change grouping, or re-sort without starting over.
Schedule recurring reports (daily through quarterly) delivered by email or webhook.
Export to CSV, Excel, PDF, or JSON, and save reports your whole team can re-run.
Report across around fifty native Workforce domains, from headcount and attendance to compensation and recruiting.

Capabilities

AI Report Generation
  • Plain-English report requests — no SQL or query syntax
  • Conversational refinement ("filter for active only")
  • Natural date expressions ("last 90 days", "this quarter")
  • Auto-detects the right data domain from your question
  • Self-correcting query engine retries on validation errors
  • One-click Quick Reports from the dashboard
Visual Report Builder
  • Point-and-click column, metric, and grouping picker
  • AI-suggested columns from a written description
  • Cross-entity reports joining employees, attendance, departments & more
  • Live preview before saving a report
  • Filter dropdowns auto-populated from your own data
  • Auto-selected charts: bar, line, pie, doughnut, area
Saved Reports & Sharing
  • Save any report as a named, re-runnable report
  • Reusable team templates (admins) for one-click reruns
  • Duplicate and remix existing reports
  • Favorite reports for quick access
  • Share reports with specific teammates
  • Private / shared / public visibility per report
Scheduling & Delivery
  • Recurring schedules: daily, weekly, monthly, quarterly
  • Email delivery with the report attached
  • Webhook (HTTP POST) delivery to your systems
  • Generate-only (no external delivery) runs
  • Run-now trigger for immediate delivery
  • Enable / disable a schedule without deleting it
  • Delivery formats: CSV, Excel, PDF, JSON
Export
  • CSV export
  • Excel export (.xlsx workbook)
  • PDF export (formatted, printable)
  • JSON export for API / downstream use
  • Per-format admin enable / disable toggles
Data Domains
  • People & organization (employees, departments, tenure)
  • Time & attendance (attendance, timekeeping, shifts & scheduling)
  • Performance & goals (reviews, OKR objectives & key results, competencies)
  • Talent (succession plans & candidates, feedback cycles & responses)
  • Compensation & leave (pay, merit cycles & calculations, leave & PTO)
  • Workforce lifecycle (recruiting candidates & jobs, onboarding, promotions, training)
  • Operations (Service Desk tickets, assets, procurement POs & requisitions)
  • Per-domain on / off toggles in settings
Adoption & Usage Analytics
  • Admin-only adoption dashboard inside the app
  • Ask AI turns, people asking, and current saved-report total
  • Ask AI completed rate (30 days) shown with its sample size
  • Report runs by data domain (top 10, last 30 days)
  • Report run outcomes: completed, failed, timed out, rejected
  • Last-used date per data domain
  • Most-asked Ask AI questions (last 30 days)
  • Daily Ask AI usage trend (last 30 days)
Limits & Specs
  • Who can use it: Managers (team-scoped domains only), Admins, Super Admins (+ app admins)
  • Data domains available: 50 native domains (7 admin opt-in)
  • Rows per report: 200 in Ask AI and the builder preview, 1,000 per saved-report run, 5,000 per scheduled delivery, 10,000 per full export
  • Preview rows: 5–50 (admin-configurable)
  • Max saved reports per user: 50, admin-configurable (0 = unlimited)
  • Schedule frequencies: Daily, weekly, monthly, quarterly
  • Pricing: License required (Standard platform tier)

Use cases

Headcount by department
Ask "Show me headcount by department" and the agent returns a grouped table with totals and a bar chart in seconds.
Attendance trend analysis
Request "Attendance exceptions last 90 days by location" to spot sites with chronic absenteeism.
Compensation benchmarking
Query "Average salary by job title and department" to support pay-equity reviews and budget planning.
Recruiting pipeline visibility
Ask "Open jobs by stage and recruiter" for a live view of your hiring funnel across active positions.
Scheduled leadership reports
Schedule a weekly headcount or attendance report to email leadership every Monday — or POST it to a webhook — with no manual reruns.
Cross-entity report in the builder
Use the visual builder to join employees with attendance and departments in one report, preview it live, and save it for the team.

FAQ

Yes. Alongside the plain-English Ask AI path, the Report Agent app includes a visual builder where you point-and-click columns, metrics, and grouping. It suggests columns from a written description, auto-populates filter dropdowns from your own data, auto-selects a fitting chart (bar, line, pie, doughnut, area), and shows a live preview before you save.

No. Describe what you want in plain English. The agent interprets your request, picks the right data source, builds the query, and can even auto-correct itself if the first attempt doesn't validate.

Around fifty native Workforce domains, including employees and departments, attendance and timekeeping, shifts and scheduling, performance reviews, OKRs, competencies, succession, feedback, compensation and merit, leave and PTO, training, recruiting (candidates and jobs), onboarding, promotions, Service Desk tickets, and assets. Seven domains are off until an admin turns them on: procurement purchase orders and requisitions, benefit plans and enrolments, expense reports and expense lines, and headcount plans. Each domain can be toggled on or off in settings. External or third-party data sources are not supported.

Yes. Say "filter for active only" or "group by location instead" and the agent modifies the existing report without starting from scratch. In the builder you can also adjust columns, filters, and chart type directly.

Yes. Any saved report can run on a recurring schedule — daily, weekly, monthly, or quarterly — and be emailed to recipients, POSTed to a webhook, or generated for download only, in CSV, Excel, PDF, or JSON. A schedule can be triggered immediately or enabled and disabled without deleting it. SFTP delivery is not yet available.

CSV, Excel workbook (.xlsx), formatted PDF, and JSON for API use. Admins can enable or disable each of the four formats in settings; the JSON switch covers file downloads only, so a webhook schedule's JSON payload is not affected by it.

Access is role-based. Admins and super admins report on every enabled domain across the organization. Managers report only on the team-scoped domains (such as employees, timesheets, safety and credentials), each limited to their own team or locations, and an admin can switch each of those off for managers. An app admin for the Report Agent manages its settings, saved reports and schedules without gaining any extra data, and an app admin of another app can report on that app's data. Reports respect private / shared / public visibility.

A report reads up to 200 rows in Ask AI and the builder preview, 1,000 when a saved report is run, 5,000 for a scheduled delivery, and 10,000 for a full export. Previews (in Ask AI and in the report builder) show 5–50 rows (admin-configurable), and each user can save up to 50 reports by default (admins can raise, lower, or make it unlimited).

Yes. Admins get a Usage Analytics page inside the app showing Ask AI turns, how many people have asked at least one question, the current saved-report total, and the share of Ask AI turns in the last 30 days that reached an answer — with the sample size beside it, so an unmeasured rate reads as unmeasured rather than as zero. Below that: report runs by data domain (top 10, last 30 days) with each domain's last-used date, report run outcomes broken out as completed, failed, timed out, and rejected, the most-asked questions, and a daily usage trend. The page is admin-only.

The Report Agent requires a license and is opt-in per tenant on the Standard platform tier — an administrator enables it from the Apps Marketplace. It is disabled by default until then. Contact your MangoApps administrator about enabling it for your organization.