Interesting Build request: other methods?

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)

Straight Line Interpolation UX.gif

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

2021-06-29_08-49-04_112857.png

2021-06-29_08-49-36_112857.png

Straight_Line_Interpolation_UX_112857.mp4

Tags

Modeling

Calculation Functions

Accepted answers

Vinay VaradarajM

Hi @erik.bangsund ,

I have made an attempt in achieving the linear chart in case the values entered fall across different years.

Please check.

Graph & data View

Screenshot 2021-06-30 at 1.18.21 PM.png

Blueprint View:

Screenshot 2021-06-30 at 1.22.42 PM.png

Hope you can extend this to your case.

Best Regards,

vinayvm

All comments

Vinay VaradarajM

Hi @erik.bangsund ,

I have made an attempt in achieving the linear chart in case the values entered fall across different years.

Please check.

Graph & data View

Screenshot 2021-06-30 at 1.18.21 PM.png

Blueprint View:

Screenshot 2021-06-30 at 1.22.42 PM.png

Hope you can extend this to your case.

Best Regards,

vinayvm

I see! By removing time from those Line Items you can see beyond the end of the year.

And using SELECT on TIME.All Periods.

Thanks!

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…