So on a Saturday morning I start a video call to make sure I have some data. We are going to record the send and receive frame rate, video loss rate, and low rate percent. Our data query will be this;
select top 10000 convert(date,ConferenceDateTime) as [Date], avg (SendFrameRateAverage) as [Send Frame Rate], avg(RecvFrameRateAverage) as [Receive Frame Rate], avg(VideoPacketLossRate) as [Video Loss Rate], avg(LowFrameRateCallPercent) as [Low Rate Percent] from QoEReportsVideoUserAgentView group by convert(date,ConferenceDateTime) order by convert(date,ConferenceDateTime)
From here we can add our 3 visuals. The first visual I add the date as the axis then the send and receive and values, and I used a multi-column bar visual
For the other 2 visuals I use and area chart with date as the axis and the value of each as the value field. You can see with the improvements of Skype for Business over time our percent of low frames and packet loss has dropped to almost nothing.
Doug Routledge, C# Lync, Skype for Business, SQL, Exchange, UC, Full Stack Developer BridgeOC Twitter - @droutledge @ndbridge