How make variable work? What proper syntax? Docs are changing every week, cant find anything relative. Using mysql. Set variable query in settings. Pulling proper values.
Trying to change table with variable dropdown, same database.
Intention is to replace table name with variable, as i select.
Why nothing works? Tried double wrapping curlies. Thx
SELECT
Str,
CONCAT(Str, ' ') as Calls,
SUM(CASE WHEN C_P = 'CALL' THEN Vol ELSE 0 END) AS call_vol,
CONCAT(Str, ' ') AS Puts,
SUM(CASE WHEN C_P = 'PUT' THEN Vol ELSE 0 END) AS put_vol
FROM $t_2023_02_17
GROUP BY Str
Order BY str