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

Once you have agreed to the terms, you can choose which dataset you wish to analyse from the "select dataset" menu at the top of the screen. (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 in a variety of formats, including Excel and CSV (comma separated values):

available download formats

The csv-geo-au format allows you to drag the downloaded file directly onto National Map to visualise it. Only some queries can be downloaded in this format – you must have broken the results down by a region field, and at most one other field. (National Map can also show longitudinal data as an animation.)

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 downloadable as separate tabs in Excel. An additional "Rotate Axes" button will also be available to change the layout of the tables; hover over the button to see a description of its effect.

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.