Forum Discussion
Add trend line along with MoM data
See attached. I made your burndown goal flexible.
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 see attached
Hi lbendlin , thanks for you quick response.
I think my question was not clear as i didn't mention few points clearly, sorry for that.
In the above table Bugs@10% column is created by me to draw a output in excel to post for this question. In reality, that column not exist so the dates from may'24 to dec'24 not available in the table. 1st Question is how to populate these dates to draw complete year chart and 2nd part is how can i make the year selection as filter and create chart accordingly.