The "Tabular Data" tab will open with a summary table that displays all of the time series. Each time series will show the total number of queries, as well as 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.
Legend of Symbols in RTS:
◊ = Root record
* = Wild Card record name
# = NX Domain root record
∑ = Aggregated Value in the table
The table will initially show only 15 time series, sorted by the total number of queries. You can adjust this number by clicking the drop-down list on the top left-hand side of the table. You can choose to show: 15, 50, 250, 1000, and All time-series in the table.
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.
If you click on the "Next" button, the table will 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.
The text box on the top right-hand side of the table, labeled "Search:" provides a convenient method for filtering time series. For example, if you type "AAAA", then only time series that have "AAAA" text in the values of their dimensions (i.e. location, record type, or record name containing an AAAA) will be displayed.
If you would like to search for more than one word, you can type a space between the search words. 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″.
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) have to be 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.
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.
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 requested time-window.)
Suppose that we have filtered our time series so that we are displaying the queries for each location.But now we would like to see the individual data points for the time series representing all the queries received by our Hong Kong name server. Click on the green "+" symbol next to the location name. This will open a chart of that time series, and below it, a table that shows the number of queries received in each of the aggregation intervals.
This sub-table provides the same navigation and paging behavior as the main table.