Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Modern Dashboard SWQL Question

I have created quite a few modern dashboards.

Here is one for last hour ingress netflow KPI.

SELECT ROUND( ( SUM(IngressBytes) / 1024 / 1024 /1024 ), 2) AS [Ingress over the last hour]
--ROUND( ( SUM(EgressBytes) / 1024 / 1024 ), 2) AS [Egress over the last 24 hours]
From Orion.Netflow.FlowsByHostname
WHERE TimeStamp > (GETUTCDATE() - 1.00)
--WHERE TimeStamp > ( GETUTCDATE() - 1 )
--AND Hostname = 'SSL VPN interface'
AND DestinationIP = 'XXX.40.200.194'

My CIO would like to have side by side KPI widgets that show last hour as in the example. and 1 that has the same hour 7 days ago to spot anomalies. Does anyone know how to do this?