I am creating an app where we can forecast project revenue into the future. I have an input for revenue, project start date, project end date, and % chance to be awarded the project. So for example if the user inputs a $300,000 project that starts January 1, and runs until March 31, I would like display that revenue as $100,000 in January, February, and March (and have it pull into a graph). I would like it to auto calculate instead of having the user input each month to make it an easier user experience. I am feeling stuck on how to do this! I am happy to clarify more if needed!
This is indeed doable, though you may need a few tricks to make it work since you do not actually have the data as a list, neither dates nor values.
So I believe you need to use Air date/time picker plugin and use the selected range of dates as list, extract months, unique elements, and that would serve as the date points. As for the values for each month, Bubble lists do not allow repeated values unless the repeating item is a Thing, so you would need to create a Thing in the database for every month and save the estimated revenue for that month then use this list as source of data for the chart.
