Query: How to create Column

Column: A collection of data presented in vertical columns (attributes), where the height of each cell is proportional to its scale.

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
Step 2: Select country
Step 3: Select indicator
  • 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. 

  • 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.

Help Documents and References

  1. Print-ready data tables in PDF format
  2. Query: How to use it
  3. Search: How to use it?
  4. Query: How to delete a saved query?
  5. Export Data: How to Bulk Download
  6. Navigation: How to find a dataset from the Home page
  7. Query: How to find the indicator for which I want data?
  8. Query: How to select multiple indicators
  9. Query: How to select the countries for which I want data?
  10. Query: How to select time and frequencies for which I want data?
  11. Query: How to change the font and font size?
  12. Query: How to change the number of decimal places?
  13. Table: How to export data from Tables
  14. Query: How to change the units
  15. Query: How to export my Query table into Excel
  16. Query: How to save queries
  17. Query: How to retrieve longer historical data series for a dataset
  18. Search Tips
  19. Browser Compatibility
  20. Query: How to create a Pie chart
  21. Query: How to create a Rating chart
  22. Query: How to create a Table
  23. Query: How to create Stacked bar
  24. Query: How to create Stacked column
  25. Query: How to create Area
  26. Query: How to create Column
  27. Query: How to create Bar
  28. Query: How to create Line
  29. Query: How to create Spline
  30. Query: How to create Scatter chart
  31. Query: How to create Bubble chart
  32. Query: How to create Treemap
  33. Query: How to create Map
  34. Query: How to change database from the query tool
  35. How do I get the underlying data in a table or a chart?
  36. Finding Data using Concept Codes
  37. Data Services
  38. Using SDMX 2.0 Web Service
  39. Using SDMX 2.1 Web Service
  40. JSON RESTful Web Service
  42. EZProxy: How to configure on the User side
  43. Table: How to select countries for which I want data
  44. Table: How to select indicators for which I want data
  45. IFS publication in PDF file – where to find
  46. Composition of Current Statistical Groups and Aggregates
  47. Bulk Download: How to extract and view data in Excel?
  48. Data services: how to get the code of a dataset and a list of all dimensions and elements?
  49. Workbook: How to show additional attributes (Country Name, Indicator Name, Database, etc.)?
  50. Workbook: How to add an attribute (Country, Time, Frequency, etc.) to a Series Tree?
  51. IFS: Accessing data vintages and print-ready data tables (PDF)
  52. DOT: Accessing data vintages and print-ready data tables (PDF)

Feedback and Knowledge Base