--- title: "SPC Characteristic data source plugin for Grafana" description: "Connect your measurement database for SPC calculations, quality metrics, and trend forecasting. See install steps and the changelog." --- > This is the Markdown version of https://grafana.com/grafana/plugins/kensobi-spccharacteristic-datasource/ # SPC Characteristic - Developer: Kenso Software - Version: 2.0.2 - [Change log](https://grafana.com/grafana/plugins/kensobi-spccharacteristic-datasource/changelog.md) ![Main dashboard](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/main.png) ![Table editor](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/table-editor.png) ![Characteristics](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/characteristc.png) ![SPC tab](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/spc-tab.png) ![Forecasting](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/forcasting.png) ![Query editor](https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource/versions/2.0.2/images/img/editor.png) # SPC Characteristic Datasource ![Dynamic JSON Badge](https://img.shields.io/badge/dynamic/json?logo=grafana\&query=$.version\&url=https://grafana.com/api/plugins/kensobi-spccharacteristic-datasource\&label=Marketplace\&prefix=v\&color=F47A20) ![Grafana](https://img.shields.io/badge/Grafana-11.6.10%2B-orange?logo=grafana) The SPC Characteristic Datasource connects your measurement database to the [SPC CAD Panel](https://grafana.com/grafana/plugins/kensobi-spccad-panel/), powering its feature annotations, control charts, capability indices, and trend forecasts — no SQL required. ![main](https://docs.kensobi.com/assets/images/main-82d6c48c7a050504f23984407338f05d.png) ## Why SPC Characteristic Datasource? The [SPC CAD Panel](https://docs.kensobi.com/assets/images/main-82d6c48c7a050504f23984407338f05d.png) 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](https://docs.kensobi.com/assets/images/characteristc-1d613be0b2be44ff7e797a5da78ab709.png) | 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](https://grafana.com/grafana/plugins/kensobi-spccharacteristic-datasource/). 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](https://docs.kensobi.com/data-sources/spc-characteristic-datasource/). ## 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](https://grafana.com/grafana/plugins/kensobi-spccad-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](https://grafana.com/grafana/plugins/kensobi-spc-panel/)** — control charts (XmR, Xbar-R, Xbar-S) for monitoring process stability over time. **[SPC Histogram Panel](https://grafana.com/grafana/plugins/kensobi-spchistogram-panel/)** — distribution analysis with histograms, bell curves, and a statistics table showing Cp, Cpk, Pp, and Ppk. **[SPC Box Plot Panel](https://grafana.com/grafana/plugins/kensobi-spcboxplot-panel/)** — box-and-whisker plots with Xf-Rf resistant control limits. **[SPC Bullet Panel](https://grafana.com/grafana/plugins/kensobi-spcbullet-panel/)** — compact bullet charts and progress bars with optional SPC metrics (Cpk, Cp, Ppk, Pp, Sigma Level) for dense KPI dashboards. **[SPC Pareto Panel](https://grafana.com/grafana/plugins/kensobi-spcpareto-panel/)** — Pareto charts for identifying the vital few defect sources. ## License This software is distributed under the [Kenso Software Commercial License](https://cdn.kensobi.com/plugins/pilot/LICENSE). Use requires a valid commercial license. No open-source rights are granted. ## Support - Contact support at - [KensoBI Discord](https://discord.gg/cVKKh7trXU)