Creating Custom Reports in Skype’s Call Quality Dashboard

In the January release of Skype Operations Framework (SOF) materials, Microsoft gave us a set of Call Quality Dashboard (CQD) templates that cover various aspects of audio quality as well as client versions and devices. They also released a series of videos showing how to navigate CQD, build reports, and investigate quality issues.
Because audio is king and the primary modality, missing from the SOF reports are details covering video and application sharing. While potentially not as important, encountering quality issues with these modalities could lead to poor end-user experience and poor adoption. Let’s dive in and build a report for these that will give us an overall health check.
First, if you haven’t yet visited it yet, log into the CQD portal at https://cqd.lync.com (side note: we will ever lose the “Lync” name?). After logging in, you will be greeted with the Summary Reports, again primarily covering audio. In the upper left, select the Summary Reports menu and switch to “Detailed Reports”.

Here you will be greeted by a set of reports titled “All Audio Streams”. On the left, select “New” to create a new set of reports. This will bring up the Query Editor. The Query Editor has 3 components to build the report for the data we are looking for:

• Dimensions – what is used to group the data, for example, by Month or Network Subnet
• Measurement – what data point(s) you want to measure, such as Poor Call Percentage
• Filter – can filter by month or by a specific Network Subnet or Building

Unleash the Potential of Power Platform With a Center of Excellence

Business innovation often comes from within. Discover how to empower innovation from non-traditional developers with the Microsoft Power Platform.

Learn More

A good example from TechNet is: “Show me Poor Streams [Measurement] by Subnet [Dimension] for Building 6 [Filter].”
Since we are just wanting to see trending information month by month, for the dimension, we will leave it at “Month Year”. For the measurements, select the plus sign and search for “video” to bring up all the video measurement options:

From here, select the following measurements:
Video Good Stream Count
Video Unclassified Stream Count
Video Poor Stream Count
Video Poor Percentage
Make sure they match this order when listed under “Measurements”. The order can be change using the up and down arrows that appear after selecting a measurement. The order of the measurements will affect how they are displayed in the graph. In this case, the top measurement for “Video Good Stream Count” will actually be the bottom portion of the bar graph.
As you go through each measurement, you can also change the properties of the element as they appear in the graph. This includes:

• Making it a bar or line graph
• The axis to place the value range
• Whether or not to stack the data
• Color to identify the measurement (default Good, Unclassified, Poor, and Poor% colors are provided)

For our graph, we are going to place all the video stream counts as a bar chart on the Left Y-Axis with stacking and the Video Poor Percentage as a line chart on the Right Y-Axis with no stacking. I also assigned the default colors for each measurement and modified the Titles to “Good”, “Unclassified”, “Poor”, and “Poor%” (these display on the legend below the graph).
For the filter, I’ve narrowed it down to October/November/December, or the 4th quarter of last year, based on the “Month Year” attribute:

Here is the overall view of our Query Builder:

Click “Save” and you have your first custom report in CQD! As you hover over each bar in the graph, more detailed information will show for each measurement:

Additional options to Edit, Clone, Delete, Download, or Export the report configuration are also available when hovering over the graph.
To make the same report for application sharing, you can clone this report and change the measurements to:
AppSharing Good Stream Count
AppSharing Unclassified Stream Count
AppSharing Poor Stream Count
AppSharing Poor Percentage
Thanks for reading!