Project Forecast Totals Based on Project Length

Hey Everyone,

New to Monday, I am looking to start a CRM for our small company. I have created a “deal” list with our active proposals that include project start dates, project end dates and project estimated sales by department. As an examplate I would have:

Now what I want to do is create a dashboard graph that will show our projected total future sales for each discipline based on our project proposals and their start and end date. So the Elec Eng value of project 1 would be split evenly between May 17 and Jul 9 and summed on the graph with the same set of data for the rest of the proposals.

This will help project our resource needs for each discipline based on our projected sales.