search

alexZaicev / Performance_Reporting

0 stars 0 forks source link

Display on the barplot only last fiscal year and current fiscal year data #1

Closed xavierschm closed 4 years ago

alexZaicev commented 4 years ago

Inside the template directory search for templates that correspond to the current and last fiscal years instead of mass loading all of the templates.

Templates supposed to have year description in start of their name, e.g. 2019-20

alexZaicev commented 4 years ago

Generator is now identifying current and last fiscal year values (e.g. 2020-21 & 2019-20) and looks for templates that start with such prefix. The mandatory file name should begin with fiscal year prefix

xavierschm commented 4 years ago

As Alex mentioned in the pull request it strictly needs templates for the fiscal year given as parameter and the fiscal year previous to that.

  • You pass you current FY start e.g. 2020 (equivalent to 2020-21) and month let's assume it's May
  • Scirpt then iterates through all excel files in the root template directory that you provide that matches the pattern
    • Last FY 2019-20
    • Current FY 2020-21
  • If for some reason last FY data is not present, it will not generate the report and throw an error

Based on the pdf Output I can say it's working (with dummy data for 2020-21, identical to 2019-20), so closing this issue

image