I am trying to use a query within a query on dashboards. Does anyone have experience with the proper syntax that is accepted by grafana? Below is a dumbed down sample of the code im trying to use. I want to filter the first Select statement with a different WHERE clause than the rest of the query.
Allocated) As Allocated FROM
help desk WHERE (
priority In ($priority))
Type = ‘FIXED’ THEN 1 ELSE 0 END) AS Fixed_In_Use,
Type = ‘FLOATING’ THEN 1 ELSE 0 END) AS Floating_in_use
Type In ($Type))
status In ($Status))