How to copy the cumulative number from previous day or 2day before or 3day before if no data.
I'd like to calculate the cumulative number from daily count and copy the cumulative number from previous day or 2day before or 3day before if no data. If there are no function on Magic ETL, it is OK to create SQL.