I'm trying to show multiple values on a chart. No matter what time range I provision, there's always a spike at the beginining of the graph, resulting in unproportional scaling of the graph:
The spike corresponds to the initial value before difference being calculated.
Here's the data source query:
SELECT
cpsd.DateTime,
cpsd.RawStatus as 'rctRfRxQualityForwardedTsbkIspCount',
n.Caption
FROM [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail] cpsd
INNER JOIN [SolarWindsOrion].[dbo].[CustomPollerAssignment] cpa
ON cpsd.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID
INNER JOIN [SolarWindsOrion].[dbo].[CustomPollers] cp
ON cpa.CustomPollerID = cp.CustomPollerID
INNER JOIN [SolarWindsOrion].[dbo].[Nodes] n
ON cpa.NodeID = n.NodeID
WHERE cp.UniqueName = 'rctRfRxQualityForwardedTsbkIspCount'
AND n.caption LIKE '%Rpt01Sc01'
GROUP BY cpsd.DateTime,cpsd.RawStatus,n.caption
ORDER BY n.caption
The chart definition:
The UNdP poll definition:
As soon as I use the Zoom button, I get correct scaling (that I would have expected on the first load):
Anybody would have an idea to get rid of that spike so I can regain some sleep?
Currently running: Orion Platform 2016.2.100, NPM 12.0.1, SAM 6.3.0, DPA 10.2.0, IVIM 2.1.2, NetPath 1.0.1, QoE 2.2.0, NTA 4.2.1