Dear Community Members,
I am trying to build the interactive KPI widget by using below query. As you can see I have map the necessary dashboard ('Interactive KPI Table - Testing' ) in the query but still I am not able to achieve the result (interactive KPI widget).
Furthermore, I have verified , the linked dashboard is present in the 'Orion.Dashboards.Instances' table. Requesting your assistance to create a interactive KPI widget.
======================================================================================
SELECT
n.TheCount,
CASE
WHEN D.Link IS NULL THEN NULL
ELSE CONCAT(D.Link, '?filters=', d.InstanceSiteId, '_Orion.Nodes_Status:eq:1')
END AS Link
FROM (
SELECT
COUNT(1) AS TheCount
FROM
Orion.Nodes N
JOIN Orion.NodesCustomProperties CP ON N.NodeID = CP.NodeID
WHERE
N.Category = 2 AND
N.Status = 1 AND
CP.Team = 'Windows'
) n
LEFT JOIN (
SELECT TOP 1
InstanceSiteId,
'/apps/platform/dashboard/' + TOSTRING(DashboardID) AS Link
FROM
Orion.Dashboards.Instances
WHERE
DisplayName = 'Interactive KPI Table - Testing'
ORDER BY
DashboardID
) D ON 1 = 1
======================================================================================
Thanks
