Create a Trend line for Cumulative Story Points Resolved in the last 4 sprints

Hi! I am using a Linear trend line for “Cumulative Story points resolved” in a timeline. I need to see a trend line for just the last 4 sprints (or 60 days). I want to keep the original timeline, but only display the linear trend line over the last 60 days. Is that possible?

Hi @Michael.Hermann ,
You can use function LinRegPoint(). Here is an example that explains, how to adjust the function so it works for you use case:

Kind regards,
Gerda // support@eazyBI.com

I think that is it! Thanks Gerda!!

1 Like