and so on, and have used it to create a stacked bar graph that displays burn-up in a graph similar to the one below.
What I am currently missing however, is the red trendline based on the observations with [Case Status] = "Closed". The trendline should be based on all of the currently available data and should aid in predicting the amount of closed cases at a specific date.
The stacked area chart visualization sadly does not currently have the option to add trendlines. Hence, I am looking for help/inspiration regarding how this could be done currently. It should preferably be done using a measure of some sort, as I would like to be able to filter on Case Status, Case Type etc.
Since I have already implemented the regression as a measure, the Line and Stacked column chart column chart actually works. It just does not look as nice, as I would have liked it to, since I wanted the stacked area chart and not stacked columns.