Forum Discussion
Add trend line along with MoM data
Hi Friends,
I am looking for suggestion on one of my requirement, please help me.
Requirement is to draw a chart with Month on Month trends of Open Bugs and a trend to show burndown of the bugs with 10%. Below is the sample data with expected out in line chart. Need you advise to write measure to calculate Bugs@10% a trend line. How this can be made dynamic w.r.t start of the month & % values used to calculate.
| MY | Bugs# | Bugs 10% |
| Jan-23 | 1200 | |
| Feb-23 | 1100 | 1080 |
| Mar-23 | 1050 | 972 |
| Apr-23 | 1025 | 875 |
| May-23 | 950 | 787 |
| Jun-23 | 940 | 709 |
| Jul-23 | 1000 | 638 |
| Aug-23 | 900 | 574 |
| Sep-23 | 850 | 517 |
| Oct-23 | 880 | 465 |
| Nov-23 | 800 | 418 |
| Dec-23 | 700 | 377 |
You suggestions are much appreciated
Thanks,
See attached. I made your burndown goal flexible.
10 Replies
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
