Plugins 〉SPC Characteristic


Developer

Kenso Software

Sign up to receive occasional product news and updates:



Data Source
commercial

SPC Characteristic

  • Overview
  • Installation
  • Change log
  • Related content

SPC Characteristic Datasource

Dynamic JSON Badge Grafana

The SPC Characteristic Datasource connects your measurement database to the SPC CAD Panel, powering its feature annotations, control charts, capability indices, and trend forecasts — no SQL required. main

Why SPC Characteristic Datasource?

The SPC CAD Panel displays CAD models in 3D with clickable feature annotations showing measurement data, trend charts, and process statistics. This datasource is what feeds it. It connects to your measurement database, lets you select which features and characteristics to query through a point-and-click interface, and returns everything the CAD panel needs in a single query:

  • Static SPC statistics — mean, control limits, Cp/Cpk, Pp/Ppk, and more per characteristic, ready to display in annotation tables
  • Time series measurements — individual measurements over time for embedded trend charts inside annotations
  • Forecast data — predicted future values with confidence bands, rendered as forecast lines in annotation charts

Features

Characteristic

FeatureDescription
Visual feature selectorBrowse and select features and characteristics by model and part — no SQL needed
Cascading filtersSelecting a model narrows the parts list; selecting a part narrows the features list
SPC statisticsMean, UCL/LCL, Cp, Cpk, Pp, Ppk, std dev, min, max, total in tolerance, and more
Built-in forecastingMoving Average, Linear Regression, Holt, and Holt-Winters — runs in the browser, no external service
Confidence bandsUpper and lower prediction intervals at 80%, 90%, 95%, or 99% confidence
Schema presetsOne-click setup for KensoBI and Q-DAS database schemas
Custom schema mappingMap any database structure with table and column pickers
PostgreSQL and MSSQLWorks with existing Grafana SQL datasource

Requirements

  • Grafana 11.6.10 or later
  • A configured Grafana PostgreSQL or MSSQL datasource pointing to your measurement database

Getting Started

  1. Install the plugin from the Grafana Plugin Catalog.
  2. In Grafana, go to Administration → Data sources → Add new data source and search for SPC Characteristic.
  3. Select your existing PostgreSQL or MSSQL datasource under Database Connection.
  4. Click Kenso Preset or QDAS Preset to auto-fill the schema, or configure table and column mappings manually.
  5. Click Save & test, then open an SPC CAD panel, select SPC Characteristic as the data source, and start building queries.

For detailed documentation, configuration guides, and examples, see the full documentation.

Part of the KensoBI SPC Suite

SPC Characteristic Datasource is part of a growing family of Statistical Process Control plugins for Grafana by Kenso Software:

SPC CAD Panel — displays CAD models in 3D with interactive feature annotations driven by this datasource. See measurement statistics, trend charts, and forecasts directly on your part geometry.

SPC Chart Panel — control charts (XmR, Xbar-R, Xbar-S) for monitoring process stability over time.

SPC Histogram Panel — distribution analysis with histograms, bell curves, and a statistics table showing Cp, Cpk, Pp, and Ppk.

SPC Box Plot Panel — box-and-whisker plots with Xf-Rf resistant control limits.

SPC Bullet Panel — compact bullet charts and progress bars with optional SPC metrics (Cpk, Cp, Ppk, Pp, Sigma Level) for dense KPI dashboards.

SPC Pareto Panel — Pareto charts for identifying the vital few defect sources.

License

This software is distributed under the Kenso Software Commercial License. Use requires a valid commercial license. No open-source rights are granted.

Support

Installing SPC Characteristic on Grafana Cloud:

For more information, visit the docs on plugin installation.

Changelog

2.0.0

Major refactor.