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
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
Detect SupportCandy tables
Pick aggregations
Lay out the grid
Save and share
Sample dashboard
Charts you can build from SupportCandy tables
Open tickets right now
Count
Tickets by status
Count
group by status
Workload per agent
Count
group by assigned_agent
New tickets per week
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.
Lifetime ♾️
Most popular
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
€749
Continue to checkoutBrowse more
- Restropress
- Woocommerce Extra Checkout Fields For Brazil
- Yith Woocommerce Wishlist
- Woocommerce Zip Checkout
- Woocommerce Multistep Checkout
- Woocommerce Paypal Payments
- Woopayments
- Advanced Shipment Tracking For Woocommerce
- Woocommerce Shipping Royal Mail
- Razorpay For Woocommerce
- Woocommerce Services
- Wp Crowdfunding
- Advanced Woo Search
- Woocommerce Gift Cards
- Checkout Plugins Stripe Woo