Stat-Xplore Documentation

The Retrieve Data Button

This section will cover:

  • Introduction
  • Retrieve Data
    • Automatically Retrieve Data
  • Knowledge Check


Introduction

The learning objectives for this page are:

  • Understanding how obtain figures on your table


Retrieve Data

In Stat-Xplore, the function of the ‘Retrieve Data’ button is to run cross tabulations and display the values of the fields that you have put in.

In Table View, you can:

  • Simply click onto the ‘Retrieve Data’ button.


Automatically Retrieving Data

By default, whenever you change the fields in the table, you need to click the ‘Retrieve Data’ button to see the values. However, this can be quite redundant and time consuming.

To avoid the need to click the ‘Retrieve Data’ button constantly, you can select the ‘Automatically Retrieve Data’ button which is located within the subsection of the ‘Retrieve Data’ button highlighted in orange:

In Employment filter added

When this option is activated, Stat-Xplore will automatically performs the cross tabulation whenever you make any changes in your currently open table.


However, for performance reasons you may find it better to leave this option turned off, especially if you are working with large tables.



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!

Navigate to the dataset ‘State Pension’, the data cube ‘State Pension from May 2018’, and open the table ‘SP3 - Age by Total Extra State Pension’. For the quarter of May 2023, how many people aged 70-74 had Total Extra State Pension?


Show/hide Solution Answer 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)