You Ask a Good Question: Top 5 Applications Per Site, by Total Bandwidth

The Ask: I’d like to be able to see the top 5 applications, per site, by total bandwidth. Basically, this graph multiple times.

 

API Guy answer:

My solution is a multi-query approach.

Step 1:

This appStats query to get the list of site names and their total traffic:

 

 Step 2:

Iterate over each site, calling an appStats() query for each one, with the site name as the filter. Here’s an example for one site:

 

You will need to then calculate the percentages based on the total for each site from the first query.