Calculate Budget Depending on Number of days in a Month

Platform discussions
,
1

Hi,

I need some help on the following.

Currently I have the following Columns
Timeline: Covers start and end date of a campaign
Budget: My campaign’s budget(in USD)
Duration: No. of days between the start and end date of the Timeline column
Daily Budget: Budget(column) divided by Duration(column)

Ideally, if I have April 1,2023 - May 31, 2023; that gives me 61 days.
With a budget of $6,100; I could get a daily budget of $100 ($6,100/61 days).

What I wanted to achieve:
A bar chart(widget) wherein it shows the monthly total budget for each month based on the columns/data above.

Kindly note that there could be a lot of campaign entries for a single month with different start and end dates. e.g.
campaign 1 - April 1 - May 31
campaign 2 - April 14 - May 18
campaign 3 - April 28 - June 02
campaign 4 - April 29 - June 11
…and the list goes on(just for reference)

Hopefully someone could help me as I am pretty new with Monday.com

2

@markm2009 Were you able to figure this out?

3

@Shya if an add-on is an option, you can create such chart with the Analytics & Reports add-on by Screenful. The chart is called Workload and it can be used for tracking allocations of any unit (such as budget) for the upcoming weeks or months. You can learn more from this blog post.

Here’s the guide to get started with a free trial.