|The My Custom Data screen allows you to group similar data items or geographic areas into custom groups which you can then add to your table.|
Groups can only include items of the same type. For example, you can create a new age group of 13 to 19 years and name it 'Teenagers', or create a new geographic area by grouping the suburbs that make up your local area.
Your groups are saved in your TableBuilder account and you can reuse them in later TableBuilder sessions. You can edit, delete and re-name your groups at any time.
The My Custom Data screen can be accessed from Table View, by clicking the link at the top left under the Table View tab.
The My Custom Data screen allows you to:
- Create custom data and custom geographic area groups.
- Use the Map to Group tools to create custom geographic area groups.
- Copy custom data groups.
- Edit custom data groups.
- Delete custom data groups.
- Rename custom data groups.
- Export a custom group.
- Edit a custom group outside TableBuilder.
- Import a custom group into TableBuilder.
6.1 Create custom data and custom geographic area groupsThe My Custom Data and Geography box appears on the top left of the screen. It displays custom groups saved in previous sessions. The tools to create new groups begin at Step 1 in the box below.
To create a new custom data group:
- At Step 1 the tree control shows all the geographical areas and data variables or 'characteristics' available for the chosen database.
- Click the expand button to expand the tree structure to show the data items or geographic areas that you wish to group.
- To select items, tick only the required items within the same classification or geographic level, or use the Select All arrow.
- Click on the Add to Current Group Items button ; your selections will appear in the Current Group Items box:
Note: Once you have added an item to the Current Group Items box, you can remove it at any time before saving your custom group:
- Select the item by clicking in the tick box beside it;
- Click on the Remove from Current Group Items button to remove it.
- Type the name of your new custom group in the text box at Step 2
- Click on the Save Group button.
- Your new custom group will now appear in the My Custom Data and Geography box in the tree structure under the original geography or classification it was created from.
The custom group can now be added to your table using the same method as adding a standard item, as shown in Chapter 4.2.
TIP: A custom group name needs to be individual. For example if you are creating the same custom group (persons aged 15 years and over) for both 2006 and 2011, call your custom groups '2006 Aged 15 years and over' and '2011 Aged 15 years and over'.
If a custom group or geographic area has already been created with the same name for another Census year, then you will get the error message: 'Group not saved, name already exists, please choose another name'.
6.2 Use the Map to Group tools to create custom geographic areasMap to Group Items enables you to use an interactive map to navigate to and select areas to include in your custom geographic area.
On the Table View tab, click on the My Custom Data link. Map to Group is accessed by clicking on the link called ‘Use Map to Group Items’ link.
To create a custom geographic areas group:
- In the drop down list above the map, select the geographic level of the areas you wish to group.
- Use the map tools to select the specific areas on the map to include in your custom geography group (see Map tools below). A maximum of 2000 areas can be selected.
- Click on the button. Your selections will appear in the Current Group Items box.
Note: The areas selected on the map will not automatically clear once you have moved them to the Current Group Items.
TIP: To remove an item from the Current Group Items list select the item by clicking in the tick box beside the item then click on the Remove from Custom Group Items button to remove it.
- Enter a name for your group in the text box at Step 2.
- Click on the Save Group button . Your new custom group will appear in the My Custom Data and Geography box in the tree structure under the original geographic level it was created from.
Use the following tools to group geographic areas into a customised region.
The Select Area tool is used to select multiple areas. It can be used to select geographic areas by clicking on them, or by clicking and dragging a rectangle around the areas to be selected.
The Deselect Area tool is used to de-select an individual geographic area by clicking on it, or multiple areas by clicking and dragging a rectangle around the areas to be deselected.
The Zoom In tool is used to get a closer view of the map. Single clicking magnifies the map by a set scale factor. The map view will then be centred at the location at which the mouse was clicked. Alternatively, performing a click and drag function on the map allows you to display a map that best fits the rectangle that was selected. See also Zoom Bar.
The Zoom Out tool is used to view a wider area of the map. The single click method allows you to see a new map view, which has been zoomed out by a set scale factor. The map view will then be centred at the location at which the mouse was clicked.
Select Area Pointer
The Select Area pointer is used to select a single geographical area. By performing a single click, you are able to highlight a specific area on the map. Any other areas already highlighted will be deselected.
6.3 Copy custom data groups
- Locate the custom data group you want to copy in the My Custom Data and Geography box by expanding the classification tree.
- Click in the tick box next to the custom data group to select it.
- Click the Copy button . A duplicate group item will appear with the name followed by “Copy 1”.
6.4 Edit custom data groups
TIP: You can cancel editing without saving by clicking on the Cancel Edit button .
- In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to edit.
- Select it by clicking in the tick box beside it.
- Click on the Edit button . The current content of the group will be listed in the Step 2: Current Group Items box.
- Add or remove items using the Add to Current Group Items and Remove from Current Group Items buttons.
- Click on the Save Group button.
6.5 Delete custom data groups
- In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to delete.
- Select the group by clicking in the tick box beside it.
- Click the Delete button . You cannot undo this action.
6.6 Rename custom data groups
- In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to rename.
- Select the group by clicking in the tick box beside it.
- Type the new name in the Rename text box. This will enable the Go button .
- Click the Go button. The screen will refresh and the custom group will be renamed.
6.7 Export a custom data groupTo download (or export from TableBuilder) a custom data group:
- Click on the custom group you wish to save in the My Custom Data and Geography box.
- Click the Download button below the box.
- A pop up box will ask you if you want to save or open the file.
- Click on 'Save the file'.
- Select the location in which you wish to save your custom group on your personal computer.
- The name of the custom group will be automatically entered. Click Save.
TIP: You can only export Customised Data and Geography from the My Custom Data Tab. Only one customised grouping can be downloaded at a time.
6.8 Edit a custom data group outside TableBuilderTo edit a custom group you have created in TableBuilder and then downloaded to your personal computer:
- Open the file from the location you have saved it to. The file will open in Excel if you have Excel installed on your computer.
Note: Some classifications codes in Tablebuilder (e.g. AGEP) have leading zeros. For these classifications once you have exported your file from TableBuilder you will need to open the file in a text editor (e.g. UltraEdit) to make any changes to the file before loading back in, as Excel will remove any leading zeros and the custom group will not load into TableBuilder.
- Make any changes to the group; for example, delete an item or add another from that classification.
Note: If the label and details for any group you wish to add other variables to must be entered correctly or the group will not work.
- Save the file as you would normally, keeping the same format.
Note: If the label and details for a group you wish to add other variables to is entered incorrectly the group will not work.
6.9 Import a custom data group into TableBuilderTo upload a custom group into TableBuilder the group you are uploading needs to be present in the database you are loading it into. For example, you are unable to load a custom group of ages into the dwellings only database because age is not available in that database. You can load it into any of the Persons, Persons and Families or Persons, Families and Dwellings databases.
To upload a custom group you need to be on the My Custom Data screen of TableBuilder.
- Go to the My Custom Data and Geography box. If you know the file path to the location of your file type it in the 'upload' text field; otherwise click on the Browse button.
- A pop up window will open. Navigate to the location of the custom group you wish to load and click Open.
- The Text field next to the browse button will be populated with the location of your file. Click on the Go button.
TIP: You can only import Customised Data and Geography from the My Custom Data Tab. Only one customised group can be uploaded at a time.
If you are successful, your group will appear in the My Custom Data and Geography box under the appropriate classification tree.
In this panel you can also remove any item you don't want in the table by marking the box and then selecting Delete.
To add the group to a table, select the Table View tab and select Customised Table.
You will see your new items listed under Custom Geography.
To add them to a table, select the items and select either Add to Row or Add to Column.
Select Retrieve Data to generate the data.
Unsuccessful Upload screen:
If the upload has been unsuccessful, the Unsuccessful Upload screen will tell you how many rows of the custom group have failed and why. You can download all errors using the button provided and then investigate the reasons for failing.
The table displayed will also tell you why an upload has failed in the Error Message column. The most common reason for a table to fail is that labels do not match. These labels can be altered to match the database you are importing into.
If you continue to have problems importing a custom group, contact the National Information and Referral Service (NIRS) (see Chapter 11).
Data & geography
Help & FAQs
- Getting started
- Opening a table or database
- Working with tables
- Large table preview mode
- My custom data
- My tables
- Working with graphs
- Working with maps
- Overview of navigation & actions toolbar
- Further assistance & information
- Method of count
- Confidentiality of Census data
User manual pdf
Services & support