Stat-Xplore Documentation

Basic Table View Functions

This section will cover:

  • Introduction
  • Sorting
  • Using Shift-Click
  • Using Select All
  • Knowledge Check


Introduction

The learning objectives for this page are:

  • How to customise the viewing experience of your table

In this section ‘Table View Functions’, we will learn more about what capabilities are available within Stat-Xplore for you to better customise your own bespoke table. Subsections labelled with ‘(Advanced)’ are features of Stat-Xplore are beneficial but not essential for the everyday user.

Feel free to browse and read whatever is relevant to you or read the whole section. If you do, we recommend that you read it in order as it has been designed to optimise your learning experience.



Sorting

To organise your table in a way that is more preferrable to you, you can click the arrow buttons to sort the table. The number of times you click matters,

  • Your first click will sort the column/row in ascending order
  • Your second click will sort the column/row in descending order
  • Your third click will sort the column/row in default sort order

To locate how to sort the table based on the values in columns, please look at the screenshot below.

Download format list

To locate how to sort the table based on the values in rows, please look at the screenshot below.

Download format list



Using Shift-Click

Rather than manually clicking though all the values that you would want to include in your bespoke table, another way you can quickly select multiple values is to use Shift-click. Rather than just one value, this selects a range of values.

For example, suppose you want to add all values of the ‘Age (bands and single year)’ field from 16-19 to 40-44. You would:

  1. Expand the ‘Age (bands and single year)’ field and select the first item in the range (in this case, 16-19):

    2. Download format list

  2. On your keyboard, hold down the Shift key and click the last item in the range (which in this case would be 40-44).
  3. Stat-Xplore will then automatically selects all the field values in between as seen below:

    4. Download format list

  4. Click either the ‘Add to Row’ button or the ‘Add to Column’ button on the top left-hand side of the menu to add the values to the table. Alternatively, you can drag and drop to the ‘Row’, ‘Column’, or ‘Wafer’, option.
  5. Stat-Xplore will input your chosen values in your bespoke table as seen below:

    6. Download format list



Using Select all

Rather than manually clicking and adding fields to a table, another way would be to use the Select all drop-down menu to quickly select a large number of field values. This is particularly useful for hierarchical fields where you can choose to select all the items at a particular level in the hierarchy.

For example, in this practical demonstration,

  1. In your currently open table, click once on the arrow to the right of the ‘National - Regional - LA - OAs’ field to open the drop-down menu.

    2. Download format list

  2. Select you desired field from the drop-down list. Stat-Xplore will then select all the available values at this level in the hierarchy.

    3. Download format list

  3. If you expand the field, you have selected, you can see that Stat-Xplore has selected all the available values at this level in the hierarchy. At the top of the menu, Stat-Xplore also tells you how many items are currently selected (in this case, 11 items):

    4. Download format list

  4. Once you are happy with your choice, click the ‘Add to Row’ button. Stat-Xplore will then add all the selected values to the row headings of your table.

    5. Download format list

  5. Finally, click the ‘Retrieve Data’ button to perform the cross tabulation.

    6. Download format list



Further Questions

If you still have any questions that are not answered in the guide, please feel free to email Stat.Xplore@dwp.gov.uk



Check your Knowledge!

When sorting your table, what does double clicking do?

A. Sort to ascending order

B. Sort to descending order

C. Sort to the default sort order

D. Nothing


Show/hide Solution Test2 Show Answer

Attachments:

SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)