Using the Table Interface

When you first arrive at the Protari Table Interface website, if OpenID Connect authentication is enabled, you will be directed to log in to your authentication service. In the case of Okta, it will look something like this:

okta login screen

You are now presented with a screen like this (noting these are only sample terms and conditions):

select a dataset

From the "select dataset" menu, choose which dataset you wish to analyse. (If only one is available, it will already be selected.) You can change the selected dataset at any time.

The query options will now appear, as below.

query options

There are three sets of options:

For example, to request a 2 dimensional table of counts by dwelling type and sex, choose these fields as follows:

menu to group results by

Depending on how the dataset has been configured (in particular its field exclusions), you may be limited in how many different fields you can select; eg. the sample dataset prevents you from choosing more than four fields at a time.

Click "Generate Results" to execute the query, which returns a table like this:

results displayed as a 2-dimensional table

In the figures, all data is dummy data. And of course, remember that the results are all perturbed.

Note there are three very useful buttons at the bottom of the screen. The first simply flips the table's axes. The second copies a link to the clipboard, which you can share with others who have access to this dataset to provide them with exactly this same query and result. And the third downloads the results as an Excel spreadsheet.

If you request the results broken down by more than two fields, the results will appear here as a series of 2D tables, and be downloaded as separate tabs in the spreadsheet.

To return the same table where only those with a specific country of birth, you could add a condition as follows:

menu to filter results by

The average value of one of the numeric fields (eg. "dollar amount") can be queried like so:

example of calculating an average

The "Expanded filters" button provides an alternative, more spacious interface to develop your query, if desired:

expanded filters

There is no additional functionality provided here. You must press "See Results" to actually execute your query.

Finally, when your login expires, you will see a message like this:

login expired

In most cases you can simply keep working and be logged in transparently, but sometimes you may need to press "Log in" again.