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.
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.
Go to Solution.
Hi @erik.bangsund ,
I have made an attempt in achieving the linear chart in case the values entered fall across different years.
Graph & data View
Hope you can extend this to your case.
View solution in original post
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.