Query: How to create a Table
Table Instructions - The sample table uses the International Financial Statistics dataset and displays Producer Price Index data for selected countries from 2000 through 2009.
Users may follow the steps below to replicate the following table.
Select Table from View
Step 1: Select time:
- Click on the plus sign next to Columns and select Time
- Place cursor over the Time attribute and click on
- From the pop up dialogue box select 2000 to 2009. Click Apply and OK.
- For detailed instructions: Query: How to select time and frequencies for which I want data?
- Click on the plus sign next to Rows and select Country
- Place cursor over the Country attribute and click on
- From the pop up dialogue box select All Item on Screen. Click Apply and OK.
- For detailed instructions: Query: How to select the countries for which I want data?
- Click on the plus sign next to Fixed and select Indicator
- Place cursor over the Indicator attribute, and click on
- From the pop up dialogue, type in Producer Price Index, All Commodities, Index. Click Apply and OK.
- For detailed instructions: Query: How to find the indicator for which I want data?
Hints:
- To quickly find an indicator, country or time period, use the provided search box.
- Place cursor over the 'play' icon to see the graph change over time or select each year separately to view it.
- The system allows dragging and dropping variables between attributes (or by clicking on the wheel icon ) in the Data View pane for different results.