Repporting on Historical Percent Loss and Response Time

BUMP

Hi,

If you are using SQL or SWQL maybe the 0 will not return any result, try condition equal or greater than 0,1 instead.

Regards,

Nope, doesn't work. Have you tried it yourself?

Deltona, were you ever able to get this working? Trying myself to get a better understanding (and reporting) of historical loss and availability metrics, and am having "unexpected results" similar to those you described initially. Would immensely appreciate any update/feedback you have regarding your solution(s) to this.

Hi nlowndes​

This turned out to be impossible in Orion, whether using field based or custom SQL reports.

The issue is that percent loss and average response do not correlate cleanly in the reports due to the summarization that occurs every 7 days, 30 days etc.

However, with help from the devs I've managed to get something that kind of works. It is not reliable but it does give me a clue as to what has happened.

FYI, there's no way around displaying 0 avg response time.

Add the following to a file and rename it to Response+Time+vs+Packet+Loss+-+Last+30+Days.xml then import it to Orion.

<Report xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Category>Custom</Category><Configs xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"><a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables"><a:DisplaySubTitle/><a:DisplayTitle>Custom Table</a:DisplayTitle><a:RefId>ca52639d-5b0a-4be5-a9c1-f3cf62abe39c</a:RefId><b:Columns><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Timestamp</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.DateTime</a:Data></a:DataType><a:DeclType>DateTime</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>true</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>5/23/2018 1:42:37 PM</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Timestamp</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|ObservationTimestamp|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Response Time History/Timestamp</b:PropertyName><b:RefId>6a623c5d-a3fc-0503-b98a-f8fcaa8927a1</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Average Response Time</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.Int16</a:Data></a:DataType><a:DeclType>Integer</a:DeclType><a:DefaultAggregation>Average</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>0</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Average Response Time</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|AvgResponseTime|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Response Time History/Average Response Time</b:PropertyName><b:RefId>1599d9e9-b41b-8d42-1a4e-ca9f4b49c0d2</b:RefId><b:Summary><b:Calculation>Average</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Center</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Percent Loss</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.Percent</a:ApplicationType><a:DataType><a:Data>System.Int16</a:Data></a:DataType><a:DeclType>Float</a:DeclType><a:DefaultAggregation>Average</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>0</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Percent Loss</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|PercentLoss|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Center</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.text.numericformat</c:PresenterId><c:Values><a:ContextValue><a:Name>NumericFormat</a:Name><a:Value>{0:0.00} %</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Response Time History/Percent Loss</b:PropertyName><b:RefId>39c10272-b838-7175-74d2-9e975b197d01</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Node Name</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>DPN-HEIMDAL</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Node Name</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|NodeName</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node/Node Name</b:PropertyName><b:RefId>6bd535da-57e0-687c-ea2f-9ef7a176282c</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Timestamp</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.DateTime</a:Data></a:DataType><a:DeclType>DateTime</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>true</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>5/23/2018 1:42:37 PM</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Timestamp</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|ObservationTimestamp|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Response Time History/Timestamp</b:PropertyName><b:RefId>4c93fc55-043c-8675-12a1-5d05e6da8aba</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Percent Loss</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.Percent</a:ApplicationType><a:DataType><a:Data>System.Int16</a:Data></a:DataType><a:DeclType>Float</a:DeclType><a:DefaultAggregation>Average</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>0</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Percent Loss</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|PercentLoss|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.text.numericformat</c:PresenterId><c:Values><a:ContextValue><a:Name>NumericFormat</a:Name><a:Value>{0:0.00} %</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Response Time History/Percent Loss</b:PropertyName><b:RefId>803f6fa7-36cd-0b36-ea3d-f66f312a45c4</b:RefId><b:Summary><b:Calculation>Average</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Average Response Time</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.Int16</a:Data></a:DataType><a:DeclType>Integer</a:DeclType><a:DefaultAggregation>Average</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue>0</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Average Response Time</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|AvgResponseTime|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Response Time History/Average Response Time</b:PropertyName><b:RefId>b4c7090b-11f6-b331-b8c0-06be1f4bc70b</b:RefId><b:Summary><b:Calculation>Average</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn></b:Columns><b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/><b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:Expression i:nil="true"/><c:Limit><c:Count i:nil="true"/><c:Mode>ShowAll</c:Mode><c:OrionServerIDsToIgnore i:nil="true"/><c:Percentage i:nil="true"/></c:Limit></b:Filter><b:Indents><b:TableIndentEntry><b:ColumnId>6bd535da-57e0-687c-ea2f-9ef7a176282c</b:ColumnId><b:HeaderStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/><b:IncludeSummaryRow>false</b:IncludeSummaryRow></b:TableIndentEntry></b:Indents><b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:SortEntry><c:Direction>Ascending</c:Direction><c:QFieldRefID>39c10272-b838-7175-74d2-9e975b197d01</c:QFieldRefID></c:SortEntry></b:Sorts><b:SummarizeMode>NoDataSummarization</b:SummarizeMode><b:TimeField xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo i:nil="true"/><c:DisplayName i:nil="true"/><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>Orion.ResponseTime|ObservationTimestamp|ResponseTimeHistory</c:Data></c:RefID></b:TimeField></a:ConfigurationData></Configs><DataSources xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><a:DataSource><a:CommandText/><a:DynamicSelectionType>Advanced</a:DynamicSelectionType><a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><a:Filter><a:Child><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.ResponseTime|PercentLoss|ResponseTimeHistory</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>0</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>&gt;</a:Value></a:Expr><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.ResponseTime|PercentLoss|ResponseTimeHistory</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>100</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>!=</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>AND</a:Value></a:Filter><a:MasterEntity>orion.nodes</a:MasterEntity><a:Name>All Nodes</a:Name><a:NetObjectId/><a:RefId>92db8941-c73f-4514-a2d6-29272fb34845</a:RefId><a:Type>Dynamic</a:Type></a:DataSource></DataSources><Description/><Footer xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:CustomText> SolarWinds Worldwide, LLC. All Rights Reserved.</a:CustomText><a:ShowCustomText>true</a:ShowCustomText><a:ShowPageNumber>true</a:ShowPageNumber><a:ShowTimestamp>true</a:ShowTimestamp><a:Visible>true</a:Visible></Footer><Header xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Logo>standard</a:Logo><a:SubTitle/><a:Title>Response Time vs Packet Loss - Last 30 Days</a:Title><a:Visible>true</a:Visible></Header><LimitationCategory>Default Folder</LimitationCategory><ModuleTitle i:nil="true"/><Name>Response Time vs Packet Loss - Last 30 Days</Name><OrionFeatureName i:nil="true"/><PageLayout xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Height>0</a:Height><a:Orientation i:nil="true"/><a:PublishingType>web</a:PublishingType><a:Size i:nil="true"/><a:Units i:nil="true"/><a:Width>960</a:Width></PageLayout><ReportGuid>1a414d36-13e6-4a4a-9da7-64d2591293e9</ReportGuid><Sections xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Section><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Columns><a:SectionColumn><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Cells><a:SectionCell><a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/><a:ConfigId>ca52639d-5b0a-4be5-a9c1-f3cf62abe39c</a:ConfigId><a:DataSelectionRefId>92db8941-c73f-4514-a2d6-29272fb34845</a:DataSelectionRefId><a:DisplayName>Custom Table</a:DisplayName><a:RefId>6d4e6047-08a7-4df5-93d3-30f5a04a66c1</a:RefId><a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider><a:TimeframeRefId>3c7340c4-720c-49dd-9150-ec8c60ba5a01</a:TimeframeRefId></a:SectionCell></a:Cells><a:ColumnGutter i:nil="true"/><a:PercentWidth>100</a:PercentWidth><a:PixelWidth i:nil="true"/><a:RefId>34a9aa8c-a1f0-4fc1-bf9b-8a337237b16b</a:RefId><a:Subtitle/><a:Title/></a:SectionColumn></a:Columns><a:RefId>dd9cd8d9-096a-497c-8b30-3249e8f4ad3b</a:RefId></a:Section></Sections><TimeFrames xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Timing"><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>51d1cbca-d54e-4292-9b22-86622c4c5152</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>08888ec3-cfcd-4cca-968c-a9c2c65173f8</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 7 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>6a40dcef-39ce-4567-83f6-43d38c658af0</a:RefId><a:Relative><a:NamedTimeFrame>Last7Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>8</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 30 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>ef8e034e-47c0-4d98-805e-f6f362ec5bbf</a:RefId><a:Relative><a:NamedTimeFrame>Last30Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>31</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 24 Hours</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>8261176d-30bd-412b-a700-6e92887acdf8</a:RefId><a:Relative><a:NamedTimeFrame>Last24Hours</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>24</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 30 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>afcd2930-28a5-490e-8726-7036a9df9da9</a:RefId><a:Relative><a:NamedTimeFrame>Last30Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>31</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 24 Hours</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>57670009-a128-48a0-ac12-2583cb683114</a:RefId><a:Relative><a:NamedTimeFrame>Last24Hours</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>24</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 30 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>5059f4fe-ebb8-46fb-9255-7b6f564579da</a:RefId><a:Relative><a:NamedTimeFrame>Last30Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>31</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 7 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>41642dd5-eaf8-4bf7-a3dd-a9a2180d5003</a:RefId><a:Relative><a:NamedTimeFrame>Last7Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>8</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 30 Days</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>3c7340c4-720c-49dd-9150-ec8c60ba5a01</a:RefId><a:Relative><a:NamedTimeFrame>Last30Days</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>31</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame></TimeFrames></Report>

Thank you, both for the response and the updated information. Fully understood re: un-clean line-up of summarization periods & timestamps. I'm looking forward to examining your report to see how you approached it.

Thanks much, again!

I took the liberty of posting this as a file in the Content Exchange to make it easier for others to download from Thwack and import into Orion. It can be found here > Response Time vs Packet Loss Last 30 Days