Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Ticket Trend Analyzer

    2

    Identify help desk spikes, MTTR trends, and automation candidates from ticket CSV exports.

    $1.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Ticket Trend Analyzer

    Ticket Trend Analyzer

    Example session with this skill installed

    Analyze help_desk_q3.csv to find why volume increased in August and identify candidates for the automation backlog.

    • Read your context and instructions
    • Compiled the ticket trend analyzer
    • Generated the document

    I have analyzed the ticket data for Q3. The volume increase in August was driven by a 42% spike in 'Access Management' during week 32, coinciding with a specific recurring subject regarding MFA resets.

    Support Trend Analysis: Q3

    MetricValueTrend
    Total Tickets4,280+12% MoM
    Avg. Resolution Time4.2 hours-0.5 hours
    Reopen Rate3.8%Stable
    Top CategoryAccess Management28% of total
    Spike DetectedWeek 32 (Aug 10-16)Z-Score: 3.1

    Automation Candidates

    • MFA Reset Requests: 412 tickets. 88% resolved in < 5 mins. Ideal for self-service bot.
    • Password Resets: 215 tickets. High volume on Monday mornings (8am-10am).
    • Software Provisioning: 180 tickets. 92% follow a standard approval pattern.

    Staffing Heatmap (Peak Hours)

    • Monday: 08:00 - 11:00 (High)
    • Tuesday: 09:00 - 10:00 (Medium)
    • Friday: 15:00 - 17:00 (Low)

    Next steps

    1. Review the generated report.html for visual charts of the August Access Management spike.
    2. Cross-reference the MFA reset subjects with the existing knowledge base to identify gaps.
    3. Open a problem record for the Week 32 outage to prevent recurrence.

    report.html

    PDF · document

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Help desk data often hides the root cause of systemic issues behind raw volume. This skill processes ticket exports to identify anomalous spikes, shifting category trends, and bottlenecks that indicate a need for problem management or automation.

    What it does

    • Detects spikes using a robust z-score based on median and median absolute deviation to isolate genuine outages.
    • Analyzes resolution metrics by calculating mean and median time to resolve (MTTR) broken down by category.
    • Visualizes staffing needs through a weekday and hour heatmap to identify peak support demand.
    • Identifies automation candidates by scanning recurring subjects and top repeat requesters for self-service potential.
    • Tracks backlog health by comparing created versus resolved rates to monitor queue growth.

    How it works

    1. Import data from a CSV export containing standard help desk fields like created, category, and status.
    2. Execute analysis using the provided Python scripts to process volume, reopen rates, and channel mix.
    3. Configure parameters such as date ranges or sensitivity thresholds for spike detection.
    4. Generate reports in plain text for quick reviews or self-contained HTML with charts for management presentations.

    Frameworks & tools

    The tool uses Python 3 for data processing and statistical analysis. It requires a CSV input with id, created, and category headers; additional fields like resolved, reopened, and subject enable deeper metrics.

    Why this beats prompting it yourself

    Manual prompts often struggle with statistical significance and calculating accurate MTTR across thousands of rows. This skill implements a robust z-score methodology that prevents a single high-volume week from skewing the baseline, ensuring anomalies are correctly flagged.

    Use cases

    • Prepare data-backed monthly service desk reviews for IT management.
    • Justify additional staffing requests using time-of-day demand heatmaps.
    • Identify specific categories requiring a new problem management investigation.
    • Find high-frequency ticket subjects that should be migrated to a self-service KB.

    Known limitations

    Requires specific CSV headers to function. High-volume datasets may require significant memory if processing locally via the Python script.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Research & Analysis.

    Requires CSV headers: id, created, and category. Memory usage scales with ticket volume. HTML reports require a browser for visualization.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    Permissions

    Terminal / Shell
    Listed1 month ago

    What's inside

    Frequently Asked Questions

    The skill requires a CSV file with 'id', 'created', and 'category' headers. Including 'resolved', 'reopened', and 'subject' fields will unlock advanced metrics like MTTR and automation candidate identification.

    Unlike basic prompts that can hallucinate averages or struggle with large datasets, this skill uses a specialized Python-based statistical engine and z-score methodology to ensure anomalies and resolution times are calculated with mathematical precision.

    Yes, you can configure custom date ranges and adjust the sensitivity thresholds for the spike detection algorithm to match your organization’s specific volume baseline.

    You will receive the core Python analysis scripts, documentation on data formatting, and templates for generating both plain-text summaries and interactive HTML reports for management.

    The skill is designed to run in any Python 3 environment; for extremely large datasets (100,000+ rows), we recommend running the script in a local environment with at least 8GB of RAM to ensure smooth processing.

    New in Research & Analysis