Tabular View

The "Tabular Data" tab opens with a summary table that displays all the time series, and for each time series it shows the total number of queries, and the minimum and maximum number of queries received during any of the aggregation intervals.

NOTE: If you wish to view aggregated data in the Tabular data tab, please first perform your desired roll-ups on the chart tab.

RTS Header

Legend of Symbols used in Real Time Stats:

◊ = root record

* = wild card record name

◊ = root record

* = wild card record name

Select Time Series

Initially, the table shows 15 time series, sorted by the total number of queries. The number of time series displayed in the table can be adjusted by using the drop-down list on the top left-hand side of the table. Clicking on the drop-down displays the number of time series you're able to show at once: 15, 50, 250, 1000, and All. For example, selecting 50 means that the table will show 50 time series at once. Or selecting "All" means that all the time series will be displayed in the table.

Number of Time Series
Paging through Time Series

On the bottom left-hand side of the table, you should see the index range of the currently displayed time series, and the total number of time series the application has loaded. The control on the bottom right-hand side of the table will help you navigate through the time series one page at a time. Clicking on "Next" on the bottom right-hand side will cause the table to show the next page of time series. Clicking on "Previous" will cause the table to show the previous set of time series, if available. Clicking on any of the numbers will cause the table to display that page of time series.

Pagination

Searching Entire Table

Although paging through the table provides a convenient way to view the time series, paging through several hundreds or even thousands of time series can be time consuming. The text box on the top right-hand side of the table, labeled "Search:" provides a convenient method for filtering time series, showing only time series that match the search text. For example, if you type "AAAA", then only time series that have an "AAAA" text in the values of their dimensions (i.e. location, record type, or record name containing an AAAA) will be displayed. In our case, as is shown on the bottom left-hand side of the table, only 626 of 4400 time series contain "AAAA".

Table Level Search


If you would like to search for more than one word, you can type a space between the search words. and Only time series that have all the space-separated words will be displayed. For example, if we type "AAAA ns10″ into the search box, then the table will only display the only 13 time series that contain both "AAAA" and "ns10″.

Search AAAA


Filtering Individual Dimensions

The table-level search is very useful for quick searches, but suppose that you want to view the total queries for each location. Recall from our earlier discussion that to view the total queries received at all locations means that the other two dimensions (record name and record type) were rolled-up.

You may have noticed a text box at the bottom of each column. For example, the "Location" column has a text box at the bottom of its column that holds the default text "Search Location". In our example, we will type the "∑" symbol into the search text boxes at the bottom of the "Record Name" and "Record Type" columns. And now we see each "Location" and the total number of queries at that location.

Filtering by location

Suppose we want to see the total number of queries for each record name. Then we place the "∑" symbol in the text box at the bottom of the "Location" and "Record Type" columns.

Filtering by Record Name

Although we use the ∑ symbol in our examples, you can type any text you like into these search boxes.

The "∑" symbol displayed in a table column means that the dimension has been "Rolled-up By". When all the search terms are removed, you may notice that the first time series in the table has the ∑ symbol in each of the three dimensions: location, record type, and record name. This time series represents the total of all the time series. Recall from our previous discussion that when we roll-up by all the dimensions, we are combining all of the time series. Interestingly, the "Total Queries" for this time series is the total number of queries your domain received during the request time-window.)

View Details of a Particular Time Series

Suppose that we have filtered our time series so that we display the queries for each location. And now we would like to see the individual data points for the time series representing all the queries received by our Seattle, Washington name server. Clicking on the green "+" symbol in the first column (unlabeled column) expands the row for Seattle, showing a chart of that time series, and below it, a table that shows the number of queries received in each of the aggregation intervals.

Time Series Details


This sub-table provides the same navigation and paging behavior as the main table.

Start Improving your DNS Performance Today