Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
astitzel
Partner
Partner

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!

 

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?