PORTAL USER GUIDE
Filter by Attribute
The Filter by Attribute tool allows you to keep some parts of a dataset based on their values.
For example, you may only want to keep part of the dataset where the value of Variable X is greater than 2, and exclude the remainder of the dataset.
For this worked example, we use filter some population data from the ABS – Data by Region dataset across the Northern Territory’s SA2 regions. A study we are working on is only interested in the SA2 regions with a population of 5,000 or more, counted in the 2016 census, so we will filter
Select the Northern Territory (ste/7) as your area.
Select ABS – Data by Region – Population & People (SA2) 2011-2018 as your dataset, with the following variables:
- Year (Filter Value: 2016)
- SA2 Code
- SA2 Name 2016
- Estimated Resident Population (Usual Residents, Erp at 30 June) Persons Total No.
Once you have set up your data, open the Filter by Attribute tool (Tools → Data Processing → Filter by Attribute). We want to exclude all values that have less than 5000 residents. The input fields we will set for this are as follows:
- Dataset Input: The dataset containing the population count. Select ABS – Data by Region – Population & People (SA2) 2011-2018.
- Attribute: The attribute we would like to filter by. Select Estimated Resident Population (Usual Residents, Erp at 30 June) Persons Total No.
- Operator: The operator type for the comparison of our attribute value below. Select Greater than or equal.
- Attribute Value: The quantity that we want to filter our data at, leaving this blank will filter by null values. Enter 5000
The input parameters are summarised in the image below, once complete click Run Tool.
Once the tool has run, click the Display button on the pop-up dialogue box that appears. This will open a window with the outputs of your Filter by Attribute tool which should look like the image below.
The output of our dataset will include only the SA2 regions in the Northern Territory that, at the time of the 2016 census, have a population of 5000 or higher. For this example, we have eleven SA2 regions.