I am working on Monday.com automation with the help of MAKE. I would like to know how can we cater for cross month data for timeline?
Timeline: 30 Oct - 3 Nov (5 weekdays)
I want to split the backlog days for above case to Oct month 4 days and Nov month 6 days. I can do so for a specific data but not sure how can I merge with my current solution.
This is my current solution without taking care of the end date of timeline, I just aggregate all the data group by start date’s month and sum the values based on the start date of timeline. Then use the summed value of each month to continue the flow. Bug here is that if is cross-month timeline, the backlog will just be parked under the start date’s month.