Select and display last available expression value for continuing demension
I have a database that has a table with dates used as a dimension in a graph. Some of the dates have a corresponding value used in an expression. When I graph this the graph stops displaying dates at the last available expression value. What I'd like the graph to display is the rest of the dates, but use the last available expression value for the missing values.
For example if I have dates 1,2,3, ... , 10 and only dates 1 - 5 have values. How can I graph dates 1 - 10 and use the value of date 5 on dates 6 - 10?
