SleekView Charts for LearnPress Certificates: issuance dashboards
SleekView Charts reads the lp_certificate custom post type alongside wp_learnpress_user_items. Certificates issued this month, share per course, certificates-per-completion ratio, and a daily issuance trend render as Number, Pie, Bar, and Area cards in WP Admin.
♾️ Lifetime License available
Certificate issuance, charted instead of listed
LearnPress Certificates extends LearnPress so a certificate post (post_type lp_certificate) is generated when a learner finishes a course. Each certificate is a row in wp_posts with post_author equal to the recipient user_id and post_meta linking back to the course (the _lp_course post_meta key). The underlying completion still flows through wp_learnpress_user_items with item_type course, status finished, and a graduation column carrying the final score.
The default LearnPress Certificates view is a paginated list inside the LearnPress admin. It shows the certificates issued with basic filters by date and course. There is no chart for issuance trend over time, no share-of-total by course, and no certificate-to-completion ratio that L&D teams use to spot template misconfigurations or hook failures.
SleekView Charts reads the certificate post type as a chartable source. A Number card anchors certificates issued this month. A Pie splits issuance by course. A Bar ranks courses by issuance ratio against finished user_items. An Area trends issuance per day so a course launch's recognition output becomes a chart instead of a guess. Filters carry across the dashboard so per-instructor or per-cohort views are two clicks.
Workflow
Build the LearnPress Certificates dashboard
Pick the certificate post type
Join completion and courses
wp_learnpress_user_items for the underlying finished row and the LearnPress course post type for readable titles. The join key is the _lp_course post_meta matching the LearnPress course id.
Configure the chart cards
Save and share
Sample dashboard
Charts from LearnPress Certificates data
Certificates issued this month
Count
Certificates by course
Count
group by course_id
Certificates per completion
Average(ratio)
group by course_id
Daily issuance trend
Count
group by post_date
Comparison
Default LearnPress Certificates list vs SleekView Charts
Default certificates list
- List view shows pages of certificates without a share-of-total chart
- Issuance trend over time is not a chart, only a sortable column
- Certificate-per-completion ratio needs a manual cross-table query
- Per-instructor breakdowns require filtering by author manually
- Filters do not carry between the certificates list and LearnPress reports
SleekView Charts
-
Issuance Number card from
lp_certificatepost_date -
Per-course donut using the
_lp_coursepost_meta key -
Certificates-per-completion ratio joining to
wp_learnpress_user_items - Daily issuance area chart
- Cards link to SleekView Tables for per-certificate drill-in
Features
What SleekView Charts gives you for LearnPress Certificates
Recognition KPIs that the L&D lead actually wants
Number cards count certificates over a date window and compare to the prior period. Filters scope the same KPI to a single course launch or cohort for clean per-campaign measurement.
Course mix as a donut
Pie cards over the _lp_course meta give a share-of-total view. Useful for spotting that a small handful of courses generate the bulk of certificates and others are silent (often a hook misfire).
Ratio cards expose template bugs
A certificates-per-completion Bar surfaces courses where finishing happens but a certificate never issues. The default list view would never make that obvious because each row is itself a successful certificate.
Audience
Who builds LearnPress Certificates dashboards with SleekView
L&D admins
Issuance trend by day and certificates-per-completion bar by course on one screen. Confirms that finishes translate into certificates and spots template bugs immediately.
Instructors
Number cards for certificates issued in their own post_author courses. Replaces a manual list scroll with a saved per-instructor dashboard variant.
Customer success
Per-cohort issuance ratio against completion. Easy to spot a corporate cohort whose finishes are not issuing certificates ahead of a renewal conversation.
The bigger picture
Why certificate issuance needs a chart, not a list
Recognition output is a number that academies report every month. How many certificates went out, which courses generated them, and what share of completions resulted in a certificate. Each one lives in the lp_certificate post type and the LearnPress user_items table already, but the default list answers none of them in a single click.
The certificates-per-completion ratio in particular is the kind of metric that exposes silent bugs (a template not assigned, a post-completion hook misfiring) which the default UI would never make obvious. SleekView Charts treats certificate posts as a chartable source with joins to user_items, with filters that carry across the whole dashboard. The result is a real recognition dashboard that updates as certificates issue.
Questions
Common questions about SleekView Charts for LearnPress Certificates
Yes. The add-on registers the lp_certificate post type and writes the _lp_course post_meta. Without it the LearnPress user_items table still records completions but there is no certificate post to chart. The dashboard described here depends on the add-on being active.
 Yes. The ratio is calculated as lp_certificate count divided by finished wp_learnpress_user_items count per course_id. Courses where the denominator is non-zero but the numerator is zero appear as zero on the Bar, which is the clearest signal of a template misconfiguration.
 Yes. LearnPress Certificates writes the template id as a post_meta on either the course or globally. SleekView resolves the template into a readable name on hover so the dashboard surfaces both volume and template per batch.
 Yes. Page-level filters propagate to every card, so picking a date range, a course post_meta, or a recipient user role recomputes every Number, Pie, Bar, and Area on the dashboard. Saved views per quarter keep historical numbers stable.
 Reads run against the live tables on dashboard load, so a certificate just issued by LearnPress appears immediately on the next refresh. Heavier aggregates (year-to-date issuance by template) opt into a configurable cache so they do not recompute on every visit.
 Yes. Each card exports its underlying aggregated rows as CSV or JSON. Useful for compliance reports where operations need a quarterly issuance snapshot to send alongside the LearnPress completion export.
 Yes. SleekView Charts reads the same lp_certificate posts the SleekView Table view writes to, so a manual issuance correction or revocation recomputes the dashboard on the next load. LearnPress hooks fire normally so downstream notifications continue to run.
 Yes. Each subsite has its own LearnPress tables and certificate posts, and SleekView Charts reads the current subsite. Cross-site aggregation is not supported, but per-site dashboards behave as expected and can be scoped per role on each subsite.
 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
- German Market
- Edd Recurring
- Wpc Buy Now Button
- Woocommerce Shipping Dhl
- Woocommerce Conditional Shipping And Payments
- Woocommerce Min Max Quantities Plus
- Woocommerce Sequential Order Numbers Pro
- Iconic Woothumbs
- Woocommerce Composite Products
- Woocommerce Tax Toggle
- Yith Woocommerce Multi Vendor
- Yith Woocommerce Name Your Price
- Yith Woocommerce Gift Cards
- Woocommerce Back In Stock Notifications
- Wpc Smart Wishlist