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.
SELECT DISTINCT
SUM(help desk.Allocated) As Allocated FROM help desk WHERE (help desk.priority In ($priority))
Select
SUM(CASE WHEN help desk.Type = ‘FIXED’ THEN 1 ELSE 0 END) AS Fixed_In_Use,
SUM(CASE WHEN help desk.Type = ‘FLOATING’ THEN 1 ELSE 0 END) AS Floating_in_use
FROM
Help desk
WHERE
(
(help desk.Type In ($Type))
and (help desk.status In ($Status))
)