Session Ready
Exercise

Adding multiple parameters to the report

Previously, you added a parameter for country to create new reports to summarize information about the investment projects for any country included in the investment_services_projects data. Now, you'll add parameters for the fiscal year and modify the existing code so that you can create new reports about the investment projects for any country and fiscal year from the investment_services_projects data.

Instructions
100 XP
  • Add an fy parameter for the fiscal year and list 2018 as the fiscal year.
  • Add parameters for the year_start and year_end dates, using 2017-07-01 for the year_start and 2018-06-30 for the year_end of the 2018 fiscal year.
  • Replace date references in the filter() on lines 64 and 65 with references to the year_start and year_end parameters.
  • In the country-investment-projects-2018 code chunk, rename the code chunk to country-annual-investment-projects and object name and object name references in the text to country_annual_investment_projects.