Compare Actual Datapoints with Derived Values

Sometimes, they claim that the mapping is wrong.
See e.g. ticket #8360 or #9304.

SELECT 
   ts.Name, vs.*, IIF([Timeseries_ID] = 222, 'SWITCH', '') 
FROM 
    influx.ValuesString vs
INNER JOIN influx.Timeseries ts
    ON vs.Timeseries_ID = ts.ID
WHERE 
    (vs.Timeseries_ID = 220 or vs.Timeseries_ID = 222) 
    AND vs.[DateTime] >= '2024-11-01'
    AND vs.[DateTime] <= '2024-11-04' 
ORDER BY
    vs.[DateTime] asc

In order to analyse this, note the following:

• There is an original series (e.g. 222, silo datapoints) and a derived series (e.g. 220, silo)

• What we show is the derived series (forward, backfilling)

• But for analysis, we can compare it with the actual datapoints