Here is the visual I created from our data. It's worth noting that when the data becomes very good in August is when the Skype for Business update to change to VBSS occurred. This seems to have greatly reduced the latency for frames, and makes for a fantastic end user experience.
select top 10000 convert(date,StartTime) as [Date], avg (RDPTileProcessingLatencyAverage) as [Latency] from ASCallAggView group by convert(date,StartTime) order by convert(date,StartTime)
In mine example, I added a constant line at 400 ms to define a good score of everything that is under that threshold.
You can also add an average, or trend line too, which can be useful to see which direction your data is heading.
The second visual we will create will measure the jitter on an application sharing conference call.
I created 3 constant lines of this visual as well, to define the levels of good, fair and poor (green, yellow, and red)
select top 10000 convert(date,ConferenceDateTime) as [Date], avg (JitterInterArrival) as [Jitter] from QoEReportsASCallListView group by convert(date,ConferenceDateTime) order by convert(date,ConferenceDateTime)
Once you have created the query return to the editor and make your area visual look something like this.
Next week we will keep adding to our visuals library, and once we have built out all the pieces we will walk through creating a dashboard.
Doug Routledge, C# Lync, Skype for Business, SQL, Exchange, UC, Full Stack Developer BridgeOC Twitter - @droutledge @ndbridge