I had a scenario posed to me and took a stab at building it. I would love to get any feedback or alternate methods of tackling this.
Scenario:
- Your user will be entering two number inputs
- These inputs will be in a module that has Months
- The user wants to see the numbers that they would need, month by month, to move in a linear fashion from the first number to the second number.
- They will see these numbers as points on a line chart, starting with the first number and ending at the second
My Method (with tweaks from @rob_marshall) (see screenshots and animated GIF)



Areas to improve: this method won't handle a period range that crosses a FY. Boo.