✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView Charts for SupportCandy Pro: dashboards from custom tables

SupportCandy stores tickets in the custom wpsc_ticket table, replies in wpsc_thread, and configurable status, priority, category, and agent groups in their own meta tables. SleekView Charts reads those tables directly and groups them into KPI cards.

♾️ Lifetime License available

SleekView Charts dashboard for SupportCandy Pro

Custom tables charted without an export step

SupportCandy is one of the few WordPress helpdesks that does not lean on custom post types. Tickets live in the wpsc_ticket table, replies in wpsc_thread, configurable lists like status and priority each have their own meta tables, and the Productivity Suite and Reports add-ons stack SLA and satisfaction-survey data into linked tables. The plugin's own reports screen draws charts, but they live in their own UI with their own filter set.

SleekView Charts reads the same wpsc_ticket table the triage screen reads. A donut groups by status column joined to wpsc_ticket_status, a horizontal bar groups by assigned_agent joined to wp_users, and a weekly area counts by date_created. The Reports add-on's number panels become four number cards, the satisfaction-survey average becomes a single sum-and-divide on the survey table, and SLA breaches become a count of wpsc_ticket rows where the due-date column is in the past.

The Pro add-ons keep adding tables: Workflows writes an automation log, Webhooks writes a delivery log, the Timer add-on writes per-ticket minute totals. Every new table becomes a chart dimension the moment SupportCandy creates it. One dashboard reads everything the triage table and the Pro add-ons already write, no spreadsheet, no scheduled export, no separate report screen.

Workflow

From SupportCandy custom tables to dashboards

1

Detect SupportCandy tables

SleekView detects SupportCandy and registers wpsc_ticket, wpsc_thread, and the meta tables (status, priority, category, agent group) as charts-ready datasets that any view can group on.
2

Pick aggregations

status drives the queue donut, assigned_agent drives the workload bar, date_created drives the weekly area, due_date drives the SLA breach number. Pick the right aggregation per card from the field list.
3

Lay out the grid

KPI numbers on top, distribution donuts and ranked bars in the middle, weekly time-series areas across the bottom. The grid reads as a week-over-week story in one view.
4

Save and share

Save as a SleekView, scope it to support-agent or support-manager role via SupportCandy permissions, and the same dashboard reopens for every agent with access on the same scope.

Sample dashboard

Charts you can build from SupportCandy tables

Four cards covering queue health, workload, SLA breaches, and weekly volume, all from the wpsc_ticket custom table and its meta links.
Number · Default

Open tickets right now

A live count of wpsc_ticket rows where the status column joins to a wpsc_ticket_status row whose closing flag is false. The headline metric every SupportCandy lead checks first.
Count
Pie · Donut

Tickets by status

wpsc_ticket rows grouped by the status column joined to wpsc_ticket_status. Surfaces queues skewed toward awaiting-customer or in-progress before the SLA timer slips past zero.
Count group by status
Bar · Horizontal

Workload per agent

Open wpsc_ticket rows per agent joined to wp_users on assigned_agent. Spot overloaded agents instantly and rebalance assignments inline without leaving the dashboard view.
Count group by assigned_agent
Area · Gradient

New tickets per week

Weekly count of wpsc_ticket rows from the date_created column. Surfaces demand spikes against weekly capacity and feeds the staffing call before SLAs start slipping across the board.
Count group by date_created

Comparison

SupportCandy Reports add-on vs SleekView Charts

SupportCandy Reports add-on

  • Reports live in their own screen with their own filter set
  • Custom field cuts not first-class on the default report charts
  • No drill-from-chart-back-to-ticket-list path in the report UI
  • Pro add-on tables (Workflows, Timer) not exposed as chart dimensions
  • Permission cuts and chart cuts maintained separately

SleekView Charts

  • Read wpsc_ticket directly without spreadsheet exports
  • Group by status, priority, category, or agent column
  • Sum Timer add-on minutes per agent or per customer
  • Count satisfaction-survey scores from the survey table
  • Permission scopes from SupportCandy applied to chart cards

Features

What SleekView Charts gives you for SupportCandy Pro

Custom-table KPIs

Read wpsc_ticket and its meta tables directly as chart sources. The same indexes SupportCandy uses for the triage screen power the chart card aggregations, so dashboard load stays under a second on big helpdesks.

SLA breach card

Count wpsc_ticket rows where the due-date column from the SLA add-on is in the past and the status row's closing flag is false. The breach pile becomes a single number on the morning dashboard.

Satisfaction average

Average the satisfaction-survey rating column from the survey add-on's table. The same number lives on the dashboard and on the agent profile, calculated identically from the same source.

Audience

Who builds SupportCandy Pro dashboards with SleekView

Support managers

Status donut, agent workload bar, SLA breach card, and weekly volume area on one screen. The morning standup runs off one dashboard instead of four filtered ticket lists.

Billing and finance

Sum Timer add-on minutes per agent or per customer for the period. The total feeds the invoice run without an export, without a CSV round-trip, and without a reconciliation step.

Quality leads

Average the satisfaction-survey table per agent. Combine with the workload bar to find agents who are fast but rated low, or slow but rated high, on the same dashboard.

The bigger picture

Why custom tables deserve a chart layer that knows them

SupportCandy's choice to use real custom tables makes it fast and easy to scale, but it also means most generic dashboard tools cannot read its data. A page builder that only reads wp_posts and wp_postmeta sees nothing on a SupportCandy site. The plugin's own Reports add-on covers the basics, but it draws its charts on its own screen with its own filter set, separate from the triage view, and Pro add-ons keep adding tables (Workflows, Timer, Webhooks) that the default reports do not chart.

SleekView Charts reads any registered data source, so wpsc_ticket, wpsc_thread, and every Pro add-on table become a first-class chart dimension. The same indexes SupportCandy maintains for triage power the chart aggregations, the same permission scopes apply, and the same numbers appear on the dashboard as on the queue. Triage and reporting share one source of truth instead of two.

Questions

Common questions about SleekView Charts for SupportCandy Pro

Yes. SleekView treats any registered data source as charts-ready, and the SupportCandy adapter registers wpsc_ticket, wpsc_thread, and the meta tables for status, priority, category, and agent groups. No staging table, no copy step, no scheduled export between the helpdesk and the dashboard.

 

Yes. The SLA add-on writes due dates into wpsc_ticket and supporting meta. Build a number card counting rows where due_date is past and the status row's closing flag is false; build a bar of breaches per agent for the same filter on the same dashboard.

 

Yes. The Timer add-on writes minute totals into its own table linked to wpsc_ticket. Sum the minutes per agent or per customer and the result lands as a chart card on the same dashboard as the queue donut. Billable totals without an export step.

 

The Satisfaction Survey add-on writes ratings into its own table linked to wpsc_ticket. Average the rating column to get a per-period CSAT number card, group by agent for a per-agent bar, or count low ratings as a quality KPI for the support lead.

 

Yes. SleekView honors SupportCandy's permission scopes. An agent's dashboard counts only the tickets they can see; a supervisor's covers their agent group; an admin's covers the full team. The same scope rules apply identically to chart cards and triage tables.

 

Yes. SupportCandy custom fields land in the ticket meta table linked by ticket ID. SleekView lists every available field key as a chart dimension or metric. A select field becomes a groupBy, a numeric field becomes a sum or average, a date field becomes a time-series.

 

Yes. Clicking a chart slice or a bar opens the underlying SleekView table with the same filter applied. From the SLA breach card, one click jumps to that list of overdue open tickets, ready for inline triage in the very next view.

 

Charts run aggregate queries on demand against the SupportCandy tables. The plugin already maintains indexes on status, agent, and date columns, which SleekView's aggregations use. On helpdesks with hundreds of thousands of tickets, dashboards load in under two seconds from the admin context.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView