need help on Modern Dashboard KPI

need to get total Count to display on KPI Widget.

SELECT TOP 100 n.DisplayName,n.Status,n.StatusLED , n.CustomProperties.Department AS CustomProperties_Department
FROM Orion.Nodes n

WHERE (Status = 2 AND n.CustomProperties.Department LIKE 'ATM Branch%')

Find more posts tagged with

SELECT COUNT(n.DisplayName) as CNT_Nodes
FROM Orion.Nodes n

WHERE (Status = 2 AND n.CustomProperties.Department LIKE 'ATM Branch%')

SELECT COUNT(n.DisplayName) as CNT_Nodes
FROM Orion.Nodes n

WHERE (Status = 2 AND n.CustomProperties.Department LIKE 'ATM Branch%')

Thanks for prompt reply

Need one more help

SELECT COUNT(n.DisplayName) as CNT_Nodes
FROM Orion.Nodes n

WHERE (n.CustomProperties.Department LIKE 'House Campus LAN%' OR n.CustomProperties.Department LIKE 'Tower Campus LAN%' AND Status LIKE '2%')

above query is not showing down nodes where ( department = House Campus LAN or Tower Campus LAN )