PORTAL USER GUIDE

Count by Attribute

The Count by Attribute tool allows you to summarise a column of data and count the total number of times a certain value has occurred within the column. It is best used for categorical or nominal values, although it can be used on any kind of attribute.

 

SET UP

For this worked example, we will summarise the mesh block categorisation of land use by in Maroochy SA3 in the Sunshine Coast with ABS Census data.

Select Maroochy SA3 as your area (Australia → Queensland → Rest of Qld → Sunshine Coast → Maroochy).

Select ABS – Usual Residential Population and Dwelling Count (MB) 2011 as your dataset, with the following variables:

  • Mesh Block Code
  • Mesh Block Category
  • SA3 Code

Inputs

Once you have set up your data, open the Count by Attribute tool (Tools → Statistical Analysis → Count by Attribute). The input fields are as follows:

  • Dataset: The dataset containing the variables you would like to summarise. Select ABS – Usual Residential Population and Dwelling Count (MB) 2011.
  • Variable: The variable we would like to count. Select Mesh Block Category.

The input parameters are summarised in the image below, once complete click Run Tool.

Outputs

Once the tool has run, click the Display output button on the pop-up dialogue box that appears. This will open up a new table of your outputs illustrating the count of mesh blocks of each land-use type that should look like the image below.

Looking for Spatial Data?

You can browse the AURIN Data Discovery:

How can you Create Impact?

Learn more about AURIN Researcher’s outcomes & real-world impact: