The Calculated Price Ratios domain provides price indices calculated from FEWS NET system data.
The Calculated Price Ratios domain is broken into three sections:
1. Search and Filter
You can search by various criteria including:
Data source document: name and organization
Data series: name, description, and metadata
Learn more about search functionality in FDE.
You can filter the available data series using one or more of the following criteria:
Period: Filters by the collection/reporting period.
Start date: Returns all data series starting on or before this date.
End date: Returns all data series ending on or after this date.
Geographic: Filters by country.
2. Data Selection
Once you have applied your search terms and filters, you will be presented with a list of all available data series that match your criteria. A data series is a collection of related data points from a single data source that are viewable as a single row within a table of data. They represent the change over time of a specific indicator. Data series are presented in table format where each row represents a single data series.
The Calculated Price Ratios domain data selection table includes the following columns:
Name: Name of the data series.
Country: Country where the exchange rate was observed.
Data source organization: The name of the organization that provided the data source document.
Data source document: The name of the document used as the primary source of information or data.
First: Period date for the first collection/reporting period in the data series.
Last: Period date for the last collection/reporting period in the data series.
Count: The number of data points in the data series.
To visualize and export data, you will need to select one or more data series by checking the box at the beginning of the row containing that series.
In addition to selecting data series, you can interact with the data selection table in the following ways:
Selected data series can be viewed in the Selected tab.
You can clear your selections using the Clear Selected button.
By default the series are ordered alphabetically by country. You can click on the header of any column to sort by that column instead of by country.
3. Data Visualization and Export
Visualize
The Calculated Price Ratios domain currently includes Chart and Table visualizations. The About tab contains descriptions and definitions of the metadata included in the visualizations and export data.
The Chart tab in the Calculated Price Ratios domain displays a line graph where each data series is represented by a line of a different color. The chart plots the USD per Domestic Currency (y-axis) against time (x-axis).
You can interact with the chart in the following ways:
Hover over a line to see more details including period and quantity.
Single click on a legend item to exclude it from the graph.
Double click on a legend item to display only its trace.
Use your mouse to draw a box around any part of the graph, or move the sliders in the timeline bar below the graph, to zoom in.
Double click on the graph background to return it into the initial zoom state.
Click the pan icon in the top right to enable panning functionality. This will allow you to use your mouse to drag the graph left or right.
Click the auto-scale icon in the top right to have the graph automatically select to the best period to display.
Click the camera icon in the top right to download the chart as a .png file.
Customize
Customization options within the Calculated Price Ratios domain allows for aggregation or conversion of the data. The available parameters are:
Reporting Schedule: Provides reporting options on a daily, weekly, monthly, quarterly and annual basis. The default reporting schedule is monthly.
Export
The Calculated Price Ratios domain includes the following options:
File format: Choose from one of the available file formats. This will apply to both downloads and refreshable links.
Download: Provides a download of a static dataset. This will export only the data series that you have selected.
Copy link: Copies a refreshable link that connects directly to the FEWS NET Data Warehouse database server, allowing Excel, your browser, or another application to automatically fetch data from the server whenever the link is accessed.