Assistance Needed: KPI Widget Configuration in SolarWinds Graphical Query Builder

KOHLIfied

Hi Folks,

I am trying to configure a KPI widget using the Graphical Query Builder in SolarWinds Modern Dashboards. However, I am unable to see any aggregation option (such as Count, Sum, Average) in the graphical selection interface.

Could you please confirm:

• Is the aggregation feature available for KPI widgets in the Graphical Query Builder?
• Are there any prerequisites or steps to enable this option?

My goal is to create a KPI that displays the count of nodes that are UP. Any guidance or documentation link would be greatly appreciated.

HerrDoktor

I never used the graphical query builder and usually build out my own queries, test them and then copy into the widget.

yours would be:

SELECT COUNT(n.NodeID) AS UpNodes

FROM Orion.Nodes AS n

WHERE n.Status = 1

hope that helps, eveven though it’s not 100% what you were asking for.