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.