Cumulative progress chart [Model attached]
Hi, See model with test data here: https://drive.google.com/file/d/1S4G3rC5-SAothJEkQBq2DhXRtWXrM9a3/view?usp=drivesdk Outout: I want to create the following graph Test data used in model Contract scheduled done Reschedule 1 Reschedule 2 Status Contract done 2023-04-25 Done 2023-04-25 2023-05-15 Done 2023-06-15 2024-01-03 2024-03-01 2024-04-05 Delayed Status missing 2024-04-03 Progressing 2024-06-03 Delayed 2024-08-01 Progressing Variables Actual The cumulative sum of "Contract done" when the status column is "Done". It should only show up until Today's date In the above example, the cumulative sum today would be 2. Planned The cumulative sum of "Contract scheduled done" It should only show from Today's date and forward In the above example, the cumulative sum would be 2 Forecast The cumulative sum of "Reschedule 2", "Reschedule 1" and "Contract scheduled done" Logic should be: If "Reschedule 2" contains data > pick this value. If "Reschedule 2" is emtpy > look at "Reschedule 1". If "Reschedule 1" contains data > pick this value. If "Reschedule 1" is emtpy > pick the value in "Contract scheduled done" Only from Today's date and forward
