Query: How to create Column
Column Instructions - The sample chart uses the International Financial Statistics dataset and displays data for Germany's Producer Price Index from 2000 through 2005.
Users may follow the steps below to replicate the below chart.
Select Stacked Column from View
Step 1: Select time:
- Click on the plus sign next to X Axis and select Time
- Place cursor over the Time attribute and click on
- From the pop up dialogue box select 2000 to 2005. 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 Legend and select Country
- Place cursor over the Country attribute and click on
- From the pop up dialogue box select Germany. 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, do a right click, go to Hierarchy and select Default. Thereafter, do the following:
- Click on Prices, then
- Click on Producer Prices, then
- Select the following indicator: "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.