I have a constant variable Shift1_StartTime whose value is '7:30:00'
and I have a SQL query
WITH DataLogKWH AS (
SELECT
SourceID,
TimestampUTC,
Value - LAG(value, 1, 0) OVER (PARTITION BY SourceID ORDER BY TimestampUTC) AS actual_value
FROM [ION_Data].[dbo].[vDataLogKWH]
)
SELECT SUM(actual_value)
FROM DataLogKWH
WHERE SourceID IN (${Compressors})
AND TimestampUTC >= CAST(CAST(DATEADD(DAY, -1, GETDATE()) AS DATE) AS DATETIME) + CAST(${Shift1_StartTime} AS TIME)
Here is my variable
and here is my SQL query in Grafana screenshot
however I try use Shift1_StartTime variable in this query, this gives me an error:
Db query error: sql: expected 30 arguments, got 0
Need help please. Thanks .

