Drill down on dimension values

We aim with Qloudstat to provide much better insights than what static reports of access logs can give. We are thrilled to announced today a major milestone with support for two dimensional queries that allow to drill down on a dimension value and plot these against a second dimension to visualize the combined metrics.

The query interface allows to specify filters on both the primary and drill down dimensions:

To illustrate this we select all URIs with Hits and Completed Download metrics that that had a 404 HTTP status code returned.

Other use cases that come into mind are to plot the combinations of URIs and operating systems in a table and compare the user agents accessing the resource over time in a line chart. Or for CloudFront, you can analyze which edge locations were accessed from which country. Or to get technical, you can plot the HTTP operations against the HTTP response code sent to the client.

Open an account and try it with our own data set!

Updated look & feel for reports

We have updated the dashboard and reports for analytics of the different dimensions and metrics with a simpler user interface.

  • Topmost you find the totals for all metrics for the selected time span including the change in percent to the previous period prominently placed below the endpoint name.

Total of metrics with change

  • The redesigned look has much less navigation overhead. Instead of a navigation menu taking screen real estate, a dropdown selector allows to quickly select the dimension you are interested in such as the URI, country or user agent. Use the tabs to switch between metrics.

Dimension and Metric Selection

  • Further down above the table listing the dimension values you can select the maximum size of the query result set. To search for specific dimension values, enter a glob pattern (Such as  *.jpg for the URI dimension or 20? for the HTTP Status Code) to only include rows with dimension values that match the input. As always, all charts have an export option to download the full result set as a spreadsheet.

Query Options

  • Scroll down for the line chart with the metric values by time (day, week or month) or a column chart showing the distribution by hours over the queried time period. Select dimension values in the table to compare these with the total.

Timeline with Filter

Stay tuned for more updates in the coming weeks. We will always refine the user interface based on customer feedback. And most notably we have drill down support coming to give insights by combining queries with a second dimension.

 

Filtering dimension values

Qloudstat allows you to draw quick conclusions about individual dimension values (such as a single resource in your container) by selecting an entry in the value result list. We now also allow to filter these table results with a custom input supporting the ? and * glob patterns to match dimension values that fit the input pattern.

Glob Pattern for URIs

To give an example consider you want to have the metrics for all files that are stored in a container with a given prefix or suffix only. Navigate to the URI dimension analytics page of your report and enter a glob pattern such as */5902/*.png to only list URIs that contain this pattern in their path. This is quite useful to filter versioned resources or limit the result list to files that are served from a specific location in your bucket or CDN origin.

The dimension values list supports multi-selection which gives you a simple way to bring the selected values in relation. When selecting multiple values a pie chart next to the table shows up with the percentage of each value compared to all selected ones.

Update: The filter with search patterns now also works for enumerated dimension values such as HTTP status code.