Count by Attribute

Introduction

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.

Inputs

To illustrate the Count by Attribute tool in use, we will summarise some meshblock data in the Sunshine Coast. To do this:

  • Select Maroochy SA3 as your area
  • Select MB Mesh Block 2011 Census for Australia as your dataset, selecting all variables.
  • Create a Choropleth of the meshblocks, selecting Mesh Block Category as your attribute, Preclassified as your classifier, and a Quantitative palette type. Your map should look something like the image below.
[Click to Enlarge]

[Click to Enlarge]

 

We are now going to summarise how many mesh blocks of each different kind of land use category there are in Sunshine Coast. To do this, open the Count by Attribute tool (Tools  → Statistical Analysis → Count by Attribute) and enter your parameters as shown below – selecting both the dataset, and the attribute field (column) you would like to summarise.

[Click to Enlarge]

[Click to Enlarge]

Once you have selected your parameters, click Add and Run to execute the tool.

Outputs

Once your tool has run, click the Display button on the pop up dialogue box that appears. This will open a table that looks like the image below, with a count of the total number of each of the mesh block land use types in Sunshine Coast

[Click to Enlarge]

[Click to Enlarge]