Part 2: Tables

Add a data table

Select the Data Table (not Time Series Table) widget from the toolbox and drag it below the three text boxes that were created in the previous tutorial. By default, the table displays demo data e.g. names and codes of the selected area.

To change the data that is displayed in the table, right click on the widget and select Properties or simply double click on the widget.

Notice that the properties for a table (and for the charts) are more complex than those for text widgets. In addition to ‘Settings’, ‘Spacing’ and ‘Quick Pick’ there is a tab called Data which will give access to the indicators from the data store.

Click the ‘Data’ tab.

The ‘Data’ tab has two separate lists, called ‘Areas’ and ‘Indicators’.

Areas‘ enable comparison values from other geographies to be added to the report.

For now make sure to untick the Show Comparison Areas? box and scroll further down.

Indicators‘ displays data that is available for the selected area:

‘Indicators’ consist of two groups. The first is data that is coming directly from the underlying feature service  – located at the top of the list it consists of names and codes for the geography your report is based on. This information shouldn’t be mixed with actual indicator data from the data store which is in the second group and most of the time these would not need displayed in widgets and so should be deselected.

All indicators with a ticked box are displayed in the table. You can either untick each of the indicators in the first group (‘Ward’) or use the help bar to deselect all indicators at once (middle button).

Tip: It is good practice to always deselect all indicators before picking the actual data for a chart. This will prevent preselections from being carried over. Make sure to not close the properties before having decided on which indicator to use, as you need at least one indicator to be selected.

Scroll down to find the data store theme tree. Click on the names or folder icons to expand or close themes. You can also use the search box to search the data store for specific terms.

Locate the ‘Children and Education’ Theme and expand ‘Census 2011 > Qualifications and students’. Make sure that no other indicator is selected and then tick the boxes for these indicators:

  • No qualifications %
  • Highest level of qualification: Level 1 qualifications %
  • Highest level of qualification: Level 2 qualifications %
  • Highest level of qualification: Level 3 qualifications %
  • Highest level of qualification: Level 4 qualifications %
  • Other qualifications %

After applying the changes, the table should now look like this:

Add comparison data from the data store

Comparison data enables either higher or lower level area data to be displayed. You can either display how an area compares to e.g. the district or a national value or you can drill down to smaller constituent areas e.g. LSOA or wards when working off district level.

The specific options in the ‘Area’ section of ‘Data’ will depend on the geography you are working with. You can choose which comparison values to use by selecting the appropriate boxes. Make sure that the ‘Show Comparison Areas?’ box is also ticked, as this option can hide all areas at once. ‘Show All Areas’ will add all areas of the same hierarchy (if they exist in the data) to your report, e.g. all other districts.

Make sure that this option is deselected and tick the box for ‘Show Comparison Areas?’.

Select Ward_Rgn* and Ward_Ctry* – this will add Region and Country as comparison areas. After applying your selection, your table should now look like this:

Change the table layout with ‘Quick Picks’

In the current layout, features are displayed as rows and indicators as columns. This layout can be changed in the properties.

Before opening the table properties, ‘Quick Picks’ tab, make sure the table has been set up as in the previous section and so should look like this:

Open the table properties, ‘Quick Picks’ tab.

Hover over the different layouts to display a description and click ‘Apply’ to confirm the changes.

 Quick Picks may override settings you have made previously in the ‘Data’ or ‘Settings’ tab e.g. the number of comparison areas. Thus it is advisable to start off with ‘Quick Picks’ before going into the more detailed settings.

The last entry ‘With Metadata Links’ is special in a sense, that it will not change any layout settings but instead add metadata links to your indicators.

After exploring the different options, select and apply ‘Single Area, One Row per Area’ as well as ‘With Metadata Links’ to add the links. Switch to ‘Data’ and untick ‘Ward_UTLA*’ that was added by the quick pick. Your table should now look like this:

Further adjust the table with ‘Settings’

While ‘Quick Picks’ are a good starting point or can be used to compare layouts quickly, the ‘Settings’ give full control over the layout and behaviour of a widget. To get more information on a specific setting, click on the help icon that shows up when you hover over a property:

To finish off creating a new Table widget redundant default settings should be edited and some relevant information should be added e.g. source information is missing.

First, go into the ‘Labels, Text & Titles’ group. Select ‘ShortName’ for Label Style to use the shorter indicator name and make the header cells more readable. Delete #DATE from ‘Indicator Label Text’ as this information is redundant – all data is coming from Census 2011.

Scroll down and put ‘Source: Census 2011’ into the Table Footer to indicate the source of your data. Lastly, put ‘Highest level of qualification’ into the ‘Table Header box.

Tip: As with text widgets, you can also use substitution variables to query data like the area name. Click on the grey pen icon next to the box and select ‘Feature Name’.

The result should look like this:

Continue reading: Part 3: Charts