6 KPIs DB Writing

<p>This workflow saves the data from the 6 KPIs into a SQLite database.</p><p>Each KPI is computed in its dedicated workflow, which captures the computation of the KPI for all the available years.</p><p><strong>HOW TO USE</strong>:</p><ol><li><p><strong>Select a year </strong>in which you want to compute the KPIs</p></li><li><p>Run the workflow executors, so that they <strong>compute the KPIs</strong>.</p></li><li><p>Save the year on the database. So if it's the first year (no tables are present) use<strong> DB writer </strong>to create the tables. If instead you want to append the tables to already existing ones (i.e., you are adding years) use <strong>DB insert</strong> nodes.</p></li></ol><p>This database will be used in another workflow (<strong>6 KPIs Data App</strong>) to interactively display all the data.</p><p></p><p>Please note that the DB is directly saved in the 6 KPIs Data App "data" subfolder.</p>