SPC Characteristic Datasource

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.

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

Feature	Description
Visual feature selector	Browse and select features and characteristics by model and part — no SQL needed
Cascading filters	Selecting a model narrows the parts list; selecting a part narrows the features list
SPC statistics	Mean, UCL/LCL, Cp, Cpk, Pp, Ppk, std dev, min, max, total in tolerance, and more
Built-in forecasting	Moving Average, Linear Regression, Holt, and Holt-Winters — runs in the browser, no external service
Confidence bands	Upper and lower prediction intervals at 80%, 90%, 95%, or 99% confidence
Schema presets	One-click setup for KensoBI and Q-DAS database schemas
Custom schema mapping	Map any database structure with table and column pickers
PostgreSQL and MSSQL	Works 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

• Contact support at https://kensobi.com/contact
• KensoBI Discord