JKC 7

The Challenge:

SpreadYearly Values Across Months

Yourteam created a summary of the total amount spent last year on each project. Thedata looks like the following:

Year     Area        Project      exp
2022     area A     projA        120
2022     area B     projX        160

Thefinance department of your company, however, would like to have a more granularoverview of the expenditures. In particular, the expenditures for projects inarea A should be spread equally across 12 months, while those for projects inarea B should be grouped by quarters. In the end, the above table should looklike the following:

Year     Area        Project      exp
2022    area A      projA         jan   10
2022    area A      projA         feb   10
...
2022    area B      projX        Q1    40
2022    area B      projX        Q2    40

Dataset: ExpendituresData on KNIME Community Hub