Grafana version: docker image grafana/grafana:11.4.0
Attempting to transform record data to series by field values and apply configuration from query
Direct MySQL data source queries:
A: i.e. select series, timestamp, value from measure ...
B: i.e. select unit, omit_min, omit_max, threshold1, threshold2 from measure_def
Apply transformations:
1- Config from query results
– able to select query source when first in transform list, but not if after prepare time series transformation.
– able to apply unit and min/max, but only 1 threshold. only applies to time series when prepare time series is disabled
– Is there a way to apply multiple threshold values from a query result?
2- Prepare time series, multi-frame time series
– needed to split out the series field from query A into dynamic series
– when enabled, config from transform 1 vanishes
I need the prepare time series as due to some specific environment and mysql constraints and would prefer to avoid rolling a custom REST microservice
I realize the prepare time series transformation is creating multi-frames, but shouldn’t these inherit configs applied to the base? If I manually set the unit etc in the panel properties they are still effective after applying the prepare time series transformation. I’d expect this to be true if applying the config dynamically before the prepare time series transformation as well.
No errors in logs
moving “config from query” after “prepare time series” makes the query B source dissapear