Populating Null Values in Month with Value Previous Month
Hello,
I have the following chart, to display the total stock over a period of time (where the stock changes cause of mutations for each article that are calculated).
The stock value is calculated by date. So the month is a total sum of stock in that month.
Problem is, when an article does not have mutations in a certain month, stock value is 0. So in some months the current stock values are missing.
Is there a way to populate the empty values with the value of last month?
Hey, the problem is, I cant really do this in the script. Since i did alot of calculations to finally got what I have now, and i want to sum them up for a month. so its not a problem in the data itself, its the used dimension
