My goal is to have an automated report using Topic Organiser. This report will contain two figs and one table where the user can enter their comments. Below are some requisites:
The Topic Organiser needs to be generated in the beginning of the year containing one document (or worksheet) named as say 'Executive View: January', based on my Organiser Template.
For the subsequent months, as the the Organiser is already create, I would like to keep adding document to it. The document will have the name 'Executive View' + <month_name>.
One picture will have the results of the KPI for the month (updated every day as a moving average) and the other picture will have the results of the same KPI in the last 3 months.
What I did so far:
The Topic Organiser Template is done (with just one document on it)
I have create another notebook scheduled to run everyday, that pulls the KPI daily results, make the month moving average, plot the results and then saves the a picture in my jupyter folder.
Another notebook is scheduled to run in the first day of each month. This one compiles the results of the same KPI in the last 3 months, plot them and then saves the plot as a picture in my jupyter folder.
I have created a third notebook to run every first of January[but after the two previous mentioned ones], which creates the Topic Organiser including the year as the prefix, for instance '2023 Site Results'. The same notebook creates one single document for January and attaches to it the previously saved figures.
Where I am stuck:
For the subsequent months, I would like to use the same template, grab the document template and add it as a new document in my already created Topic Organiser, keeping the previous months intact. I could not figure out how to make this yet?
How would you recommend to achieve this? Am I in the right path or would you suggest a different way?