SleekView Charts for SupportCandy
SupportCandy v3 stores tickets, threads, agents, and custom fields in dedicated wpsc_ tables. SleekView Charts reads them directly and turns status, category, agent, and last-activity into a dashboard.
♾️ Lifetime License available
Custom-table tickets, summarized as charts
SupportCandy v3 moved away from postmeta and now keeps tickets, threads, agents, categories, and custom field values in dedicated wpsc_-prefixed tables. The Productivity Suite add-on runs reports in its own UI and the default admin shows lists. Neither lets a support lead glance at queue distribution, workload balance, or trend without opening multiple screens.
SleekView Charts reads the same wpsc_ tables the triage table already does. Status becomes a donut card. Category becomes a ranked bar. Tickets per agent come from the assignment column. A weekly area chart of new tickets uses the created-on timestamp on wpsc_ticket. Custom fields stored in wpsc_cf_* value tables join in as numeric or grouped dimensions, so a NPS field or a severity rating can drive its own chart card.
Inline triage stays in the table view. Charts add the reporting view that the plugin admin is missing. Both run against the same SQL source, both apply the same agent-group capability checks, and both update the moment a ticket is created or updated. SupportCandy keeps owning the data layer; SleekView owns the reading experience.
Workflow
From wpsc_ tables to a reporting dashboard
Detect the schema
Pick chart dimensions
Compose the dashboard
Save and apply caps
Sample dashboard
Charts you can build from SupportCandy data
Open tickets
Count
Status mix
Count
group by status
Workload by agent
Count
group by assigned_agent
New tickets per week
Count
group by created_on
Comparison
Productivity Suite reports vs SleekView Charts
Productivity Suite reports
- Productivity Suite reports run in their own UI, not next to the queue
- No drag-and-drop dashboard composition
- Custom field values from wpsc_cf_* are not first-class chart dimensions
- Time-series volume needs CSV export and a spreadsheet pivot
- Agent workload is a separate report, not a unified dashboard card
SleekView Charts
- Read directly from wpsc_ticket and wpsc_ticket_thread
- Custom fields from wpsc_cf_* tables as chart dimensions
- Status donut, workload bar, and volume area on one view
- Capability checks apply identically to charts and tables
- Drill from any chart back into the underlying queue
Features
What SleekView Charts gives you for SupportCandy
Direct from wpsc_ tables
SleekView queries the SupportCandy tables directly. No postmeta hacks, no schema duplication, no sync layer. The dashboard always agrees with the queue.
Custom field aggregations
Each custom field type has its own value table. SleekView joins them so a severity rating or a customer-tier dropdown drives a chart card the same way a built-in column would.
Group-aware reports
Agent groups in SupportCandy already constrain table visibility. The same constraints apply to chart aggregations so each supervisor sees only their group's data.
Audience
Who builds SupportCandy charts dashboards with SleekView
Support leads
A queue-health dashboard with status donut, workload bar, and weekly volume. Replaces a daily standup spreadsheet with a one-click reopen.
Helpdesk admins
Audit category mix and custom-field coverage over rolling 30-day windows. The bar of tickets-by-category names the next workflow to automate.
Operations
Volume trend by week against agent count. The area chart tells operations when to hire before the SLA chart turns red.
The bigger picture
Why custom-table helpdesks deserve native dashboards
SupportCandy made the right architectural call by moving off postmeta and into properly normalized custom tables. The cost of that decision is that generic reporting tools (the WordPress admin, generic post-type plugins) can no longer help with reporting. Productivity Suite fills part of that gap with hard-coded reports, but a hard-coded report cannot answer the question a support lead just thought of.
SleekView Charts treats wpsc_ticket and its companions as first-class data sources. Any column becomes a chart dimension. Any custom field becomes an aggregation.
Any time field becomes a series axis. The dashboard is composed visually, saved as a view, and reopened in one click. The result is the reporting layer the plugin's data model deserves, built on top of the schema rather than around it.
Questions
Common questions about SleekView Charts for SupportCandy
Yes. SleekView checks the schema and reads from CPT-style storage on v2 or the wpsc_ tables on v3. The chart-building experience is the same; only the source query changes. Migrations from v2 to v3 keep dashboards working because the column names line up across both schemas.
Yes. SupportCandy stores each custom field type in a dedicated wpsc_cf_* value table. SleekView joins them so dropdowns become groupBy options and numeric fields become Sum or Average aggregations. NPS, customer tier, severity rating, all available as chart dimensions.
Agent-group capabilities apply to chart queries the same way they apply to table queries. A supervisor sees their group's tickets in every aggregation, an agent sees their assigned tickets, an admin sees everything. The dashboard does not need a separate permission layer.
Charts are read-only views over the data. They do not write to wpsc_ tables and do not trigger Workflows. Inline edits from a SleekView table go through SupportCandy's data layer normally; the charts dashboard reads whatever the table writes.
Yes. Clicking a slice on the status donut opens the table view filtered to that status. Clicking an agent's bar opens their queue. Each chart slice carries the filter that produced it, so triage starts one click away from any insight.
Yes. The SLA add-on writes due-date and breach-status fields that SleekView reads. Build a number card for tickets past due, a bar of breach count per agent, or an area chart of weekly breach trend. Any SLA field surfaces as a chart dimension.
Aggregate queries run on demand against the wpsc_ tables. The tables are normalized and indexed for the operations SupportCandy itself performs, and chart aggregations use the same indexes. On helpdesks with tens of thousands of tickets dashboards load in well under a second.
Yes. Any chart card exposes its underlying data for CSV export. Useful for monthly reporting, sharing with a non-WP stakeholder, or feeding numbers into another reporting tool. The export matches what the chart shows, including filters.
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 checkout