No data or chart options shown when querying Timescale

lastditchusername commented 7 hours ago

I'm unable to get the SPC chart to show anything with our data. Notes from troubleshooting and checking other issues for solutions:

The Grafana random walk query does render as expected
Query is in "Table" format
Time is detected as a regular timestamp
Dashboard crashes when any of "Feature", "Nominal", or "Control" are not present in query
Query does return data when "Table View" is selected
If "Control" is set to 0, no chart is displayed at all, and Constants cannot be added to the chart
- If "Control" is set to anything else, a "No Data" error is shown in the chart area, and value can be selected as a constant

Query being used is as below:

SELECT
  CAST(measured_value AS FLOAT) as value,
  time,
  parameter_name as "Feature",
  target as "Nominal",
  upper_bound,
  lower_bound,
  0 as "Control"
FROM xx_database_xx
WHERE ( [variables] ) 
AND $__timeFilter("time")

mrtomeq commented 6 hours ago

To use control limits from a dataset, you will need to set up two separate queries: one for the control limits (feature information) and another for the measurement data. Currently, it appears you have only one query configured, and it is solely for the control limits. The measurement query is missing.

mrtomeq commented 5 hours ago

By the way, version 2 of the plugin is currently under review by Grafana and will be released in the coming days. It is a complete rewrite with a new and improved editor.

Our documentation has already been updated: https://docs.kensobi.com/panels/spc-chart/spc

While we wait for it to be published in the Grafana plugin repository, you can install it manually from https://github.com/KensoBI/spc-chart/releases/tag/2.0.1

KensoBI / spc-chart

No data or chart options shown when querying Timescale #57