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:
You are now presented with a screen like this (noting these are only sample terms and conditions):
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.
There are three sets of options:
- the aggregation type, which defaults to "count"
- which fields to break the results down by
- what conditions to place on the data shown.
For example, to request a 2 dimensional table of counts by dwelling type and sex, choose these fields as follows:
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:
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):
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:
The average value of one of the numeric fields (eg. "dollar amount") can be queried like so:
The "Expanded filters" button provides an alternative, more spacious interface to develop your query, if desired:
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:
In most cases you can simply keep working and be logged in transparently, but sometimes you may need to press "Log in" again.