Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
astitzel
Partner - Contributor II
Partner - Contributor II

Trend Line based on Future Date

Hi!

I am building a burn up chart for a software development project scheduled to go live on Jan 1, 2022. I am trying to impose a trend line over the data set that calculates slope based on months to 1/1/2022 to see how progress tracks against a rough average velocity, but I can't figure out how to update the line to calculate based off of a date in the future. I've included a screenshot of the current chart below for reference.

astitzel_0-1600286537881.png

Is is possible to restructure the formula for the trend line to instead calculate slope based on months to Jan 2022?

Thank you in advance!

 

Labels (1)
1 Reply
Go-Anna
Contributor III
Contributor III

Hi Astitzel,


I am afraid I don't have an answer to your question, I am really intrigued as to how you managed to achieve your trend line on your accumulated values.


I have used this formula:
linest_m(total aggr(if(sum([Hours Worked]),sum([Hours Worked])),Period),Period)*only({1}Period)+linest_b(total aggr(if(sum([Hours Worked]),sum([Hours Worked])),Period),Period)


But when I accumulated the values, the line was no longer lineal!


Can you share how you achieved your trend-line?