Interesting Build request: other methods?

erik.bangsund
erik.bangsund
in Modeling

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:

  1. Your user will be entering two number inputs
  2. These inputs will be in a module that has Months
  3. 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.
  4. 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)

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

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

Straight Line Interpolation UX.gif

 

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

 

Tagged:

Best Answer

  • Vinay VaradarajM
    Vinay VaradarajM
    Answer ✓

    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

     

     

Answers

  • erik.bangsund
    erik.bangsund

    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!

Categories