Angle up or down a trendline to form a cone of uncertainty on a burn-up chart

[Stef]

Hello EazyBi Forum,

Long time reader, first time poster here.
I’m trying to create a cone of uncertainty to see a best case or worst case scenario and the impact it has on my burn-up chart.

The following is what I’m trying to do:

My Story points done trend line is a measure I made using the following input:

Cache(
LinRegPoint(
DateToTimeStamp([Time].CurrentHierarchyMember.StartDate),
Filter(
[Time].CurrentHierarchyMember.Level.Members,
DateBetween([Time].CurrentHierarchyMember.StartDate,
‘6 months ago’,‘Now’)
),
[Measures].[Cumulative Story Points Done],
DateToTimeStamp([Time].CurrentHierarchyMember.StartDate)
)
)

I was hoping to see what would happen if starting at the Today mark my teams would ramp up their velocity by 20% by putting in overtime for example.
Anyone have any advice on how to do this?

Kind regards

[SoTh]

You can adapt this awnser to get what you want!

Display straight lines in burnup chart

I would like to display several straight lines in burnup chart. In this case I do not want to use the Predicted dates that you have in EazyBI. I would like straight lines where I can define the x,y start and xy finish. See example below. I do see sophisticated extrapolations in EasyBI, in this case I would like simplicity of manually Then adjusting visually to best fit the data. It must be simple as I am simple PM and not so good with EazyBI language! Thanks for any guidance. I MIGHT…

[gerda.grantina]

Hi @Stef,
Congrats on your first post

I see that @SoTh already has provided the answer that could work for you.

Additionally, to that I wanted to share this eazyBI report from our Demo account that also has prediction measures (“Project prediction low”, “Project prediction high”) for low or high probability - Project Prediction report - Issues - Jira Demo - eazyBI

best,
Gerda // support@eazybi.com