Introduction
The following list of new features, tasks, and resolved bugs are included in the latest Sprint 21.09.3 release to FDW/FDE:
 
  
  
 Features
- 
  Check availability of data for the base period for each component selected for a Calculated Price Index https://fewsnet.atlassian.net/browse/DATA-994 
- 
  Features update for the forex chart and option tabs of the FDE https://fewsnet.atlassian.net/browse/DATA-1018 
- 
  Improve performance by reducing query count for getting exchange rates https://fewsnet.atlassian.net/browse/DATA-1040 
- 
  Applying other domain filter behavior to the /api/ endpoint via the router https://fewsnet.atlassian.net/browse/DATA-1046 
- 
  Make exchange rate country filters use country currency assignments https://fewsnet.atlassian.net/browse/DATA-1127 
- 
  Interpolated Data Points should have Status = Interpolated rather than Collected https://fewsnet.atlassian.net/browse/DATA-1128 
- 
  Include geographic fields in Exchange Rate Extracts https://fewsnet.atlassian.net/browse/DATA-1138 
 
  
  
 Tasks
- 
  Disable node creation while there is no data https://fewsnet.atlassian.net/browse/DATA-1143 
- 
  Fix Drupal nodes initial caching https://fewsnet.atlassian.net/browse/DATA-1139 
 
  
  
 Bugs
- 
  Percentage changes of the one month, one year and five-year averages are all showing the same values as of the last day of the month https://fewsnet.atlassian.net/browse/DATA-1028 
- 
  Enketo reports support email as support@example.org https://fewsnet.atlassian.net/browse/DATA-1036 
- 
  Review rendering speed of IPC layer in COVID-19 visualization, add vector tiles caching https://fewsnet.atlassian.net/browse/DATA-1097 
- 
  Image attachments do not work with FEWSNET KoBo https://fewsnet.atlassian.net/browse/DATA-1107 
- 
  Error with geographical unit in calculated price index domain https://fewsnet.atlassian.net/browse/DATA-1175 
- 
  Dataset admin only allows 10 dataseries records at a time https://fewsnet.atlassian.net/browse/DATA-1177 
 
  
  
 Features 
 
  
  
 Check availability of data for the base period for each component selected for a Calculated Price Index https://fewsnet.atlassian.net/browse/DATA-994
- 
  This enhancement is about adding a validation error message that states: The index component must have data points for the base period, which notifies the user that the index component does not have data for the given base period as shown below ;
 
  
 
  
  
 Features update for the forex chart and option tabs of the FDE https://fewsnet.atlassian.net/browse/DATA-1018
- 
  This feature corrects an error which showed two indicators on the chart at one time, which was visually confusing. This change shows one indictor at a time and USD per domestic currencyis the default indicator selected.
 
  
  
 Improve performance by reducing query count for getting exchange rates https://fewsnet.atlassian.net/browse/DATA-1040
- 
  This feature is about generating fewer queries which helps the system to perform faster exchange rate calculations. 
 
  
  
 Applying other domain filter behavior to the /api/ endpoint via the router https://fewsnet.atlassian.net/browse/DATA-1046
- 
  This feature is about enhancing the /api/ endpoint(i.e http://fdw.fews.net/api/ ) to only show thethe semi-structured data series end points for users who have access. 
 
  
  
 Make exchange rate country filters use country currency assignments https://fewsnet.atlassian.net/browse/DATA-1127
- 
  This feature enhanced the search in the Exchange Rate data series endpoint (/api/exchangerate) so that it used all country currency assignments instead of just the country assigned to the Data Series. For example: https://fdw.fews.net/api/exchangeratevalue/?format=html&country=ethiopia , https://fdw.fews.net/api/exchangeratevaluefacts/?format=html&country_code=ET , and https://fdw.fews.net/api/exchangerate/?format=html&country_code=ET 
 
  
  
 Interpolated Data Points should have Status = Interpolated rather than Collected https://fewsnet.atlassian.net/browse/DATA-1128
- 
  This feature is about setting the status Interpolatedfor the Interpolated Data Points values , for instance; https://fdw.fews.net/api/marketpricefacts/?format=csv&schedule=Monthly&dataseries=761&fields=simple&interpolate
 
  
  
 Include geographic fields in Exchange Rate Extracts https://fewsnet.atlassian.net/browse/DATA-1138
- 
  This enhancement is about allowing the inclusion and ordering of the geographic fields (i.e geographic_group,fewsnet_region,country,admin_1,admin_2,market,longitudeandlatitude) in the API end points of the exchange rate extracts:
https://fdw.fews.net/api/exchangeratevalue/?format=csv
https://fdw.fews.net/api/exchangerate/?format=csv
https://fdw.fews.net/api/exchangeratevaluefacts/?format=csv
 
  
  
 Tasks
 
  
  
 Disable node creation while there is no data https://fewsnet.atlassian.net/browse/DATA-1143
- 
  This task was about disabling the Drupal node creation for a data collection that does not contain any data. Therefore there should no longer be nodes published if there is no data attached. 
 
  
  
 Fix Drupal nodes initial caching https://fewsnet.atlassian.net/browse/DATA-1139
- 
  This task was about correcting the caching for the PNG links of the Drupal nodes, so that the correct PNGs show up and quickly when clicked. 
 
  
  
 Bugs
 
  
  
 Percentage changes of the one month, one year and five-year averages are all showing the same values as of the last day of the month https://fewsnet.atlassian.net/browse/DATA-1028
- 
  The system was incorrectly showing the value of the last day of the month which was used for the calculating the percentage change values of one month, one year and five-year when a daily collection schedule was aggregated and this was resolved. 
 
  
  
 Enketo reports support email as support@example.org https://fewsnet.atlassian.net/browse/DATA-1036
- 
  Enketo reports the support email as support@example.org , which was not the correct email, and so this now redirects to the email helpdesk@fews.net . 
 
  
  
 Review rendering speed of IPC layer in COVID-19 visualization, add vector tiles caching https://fewsnet.atlassian.net/browse/DATA-1097
- 
  There was a performance issue in rendering the individual country IPC data on the COVID-19 map via the fews.net website and this was resolved. 
 
  
  
 Image attachments do not work with FEWS NET KoBo https://fewsnet.atlassian.net/browse/DATA-1107
- 
  There was an issue in attaching images to FEWS NET Kobo Toolbox server and this was resolved . 
 
  
  
 Error with geographical unit in calculated price index domain https://fewsnet.atlassian.net/browse/DATA-1175
- 
  There was an error in creating a calculated index (i.e., https://fdw.fews.net/en/admin/price/calculatedindex/add/ ) and this was resolved and the functionality is working as expected. 
 
  
  
 Dataset admin only allows 10 dataseries records at a time https://fewsnet.atlassian.net/browse/DATA-1177
- 
  There was an issue in creating dataset from the admin page of the FDW ( https://fdw.fews.net/en/admin/price/pricedataset/add/ ) i.e it was allowing 10 records of data series to be selected at a time and this was resolved and the functionality is working as expected. 
 
 
  
 
 
 
