Forum Discussion
Add trend line along with MoM data
See attached. I made your burndown goal flexible.
Thanks for the solution. Solution is very dynamic and perfectly meets my requirement. I will try to understand the measure written and functions used.
Can i ask here how can we make this into look like forecast to predict how the burndown looks when the we go with different percentages. eg I have data for Jan'24 & Feb'24, how can we draw a chart to show where it will reach by dec'24 if we go with N%.
You can duplicate the measure and fix it at certain percentages, say 5% or 10%, and add that as a line in the chart - ideally a dashed line.
Hi lbendlin , I did tried duplicating the measure but it didn't work. May be i was not clear in my question in previous post.
What i am trying is to show the data for Previuos & current years scenarios,
Previous year : what could be my burndown if specific percentage selected against the actual - This is working as expected
Current Year : What will be my forecasted burndown for next 12 months - I am not able to get
This should work on same data sets, when selected 2024 it should populate brundown for 12 months considering the Jan'24 as baseline
This is what i am getting, but not able to add it for 12 months
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.HI lbendlin ,
Here i am attaching complete set of sample data and the required out put. Please suggest how the existing measure can be modiy to get the required output.
I would need filter on Year and Product. On all filter the data should work and provide burndown trend.
Sample Data
MY Product Bugs# Bugs @10% Jan-23 Product1 1200 Feb-23 Product1 1100 1080 Mar-23 Product1 1050 972 Apr-23 Product1 1025 875 May-23 Product1 950 787 Jun-23 Product1 940 709 Jul-23 Product1 1000 638 Aug-23 Product1 900 574 Sep-23 Product1 850 517 Oct-23 Product1 880 465 Nov-23 Product1 800 418 Dec-23 Product1 700 377 Jan-24 Product1 650 Feb-24 Product1 600 585 Mar-24 Product1 580 527 Apr-24 Product1 590 521 May-24 Product1 516 Jun-24 Product1 511 Jul-24 Product1 506 Aug-24 Product1 501 Sep-24 Product1 496 Oct-24 Product1 491 Nov-24 Product1 486 Dec-24 Product1 481