How to enable link mapping for the proportional widgets in Modern dashboard

kishore.jagati

How can I enable link mapping (UP,Down, Unmanaged,.....) for the below proportional widgets.

SELECT COUNT(NodeID) as value, Status as status FROM Orion.Nodes GROUP BY status ORDER BY value DESC

SELECT COUNT(1) AS Count_Items , Status FROM Orion.APM.Application GROUP BY Status

SELECT COUNT(1) AS Count_Items , Status FROM Orion.NPM.Interfaces GROUP BY Status

luiz.andrade

Hello Kishore,

Yes, you can make it clickable.

Step 1 - Create a Dashboard with a table widget listing all Nodes. You can use the SWQL example below to create your table widget.

**Take note of the Dashboard Name as you will use it later on Step 2

Select N.Caption as [Node Name]
, N.MachineType as [Machine Type]
, N.IP_Address as [IP Address]
, N.LastSystemUpTimePollUtc as [Last Successful Poll]
, N.VendorIcon as [Vendor Icon]
, N.Status, N.DetailsURL as [Details URL]
, N.Location, N.Contact, N.StatusDescription
From Orion.Nodes N

Step 2 - On your proportional widget, use the SWQL below.

**Replace the DASHBOARD_NAME_FROM_STEP1 with the Dashboard Name from Step 1

SELECT
COUNT (1) AS Quantity
,[N].Status AS [Node Status]
,[S].[StatusName]
,CASE WHEN N.Status=1 then '#00A753'
ELSE S.Color
END AS Color
,'status_' + S.IconPostfix as Icon
,CASE WHEN D.Link is null then NULL
ELSE CONCAT(D.Link,'?filters=', N.InstanceSiteId, '_Orion.Nodes_Status:eq:', N.Status)
END AS Link
FROM Orion.Nodes AS [N]
INNER JOIN Orion.StatusInfo S ON N.Status=S.StatusId
LEFT JOIN ( SELECT TOP 1 '/apps/platform/dashboard/' + TOSTRING(DashboardID) as Link
FROM Orion.Dashboards.Instances
WHERE DisplayName = 'DASHBOARD_NAME_FROM_STEP1' ORDER BY DashboardID ) D ON 1=1
GROUP BY N.Status, [S].[StatusName], S.Color, S.IconPostfix, D.Link, N.InstanceSiteId
ORDER BY [N].Status

Step 3 - Configure the proportional widget like below:

I hope this information is helpful.

Please let me know if you have any further questions.

All the best.