Timeseries data for missing timestamp

[Former Member]

Hi,

I have table of records in following format:

ID | DATE | COST

1 | 01/01/2018 | 5

1 | 01/05/2018 | 0

1 | 01/06/2018 | 5

1 | 01/10/2018 | 0

I want to build a timeseries chart in SAC which keeps the previous value for missing dates such that the chart looks

Is there a way to generate such a timeseries chart in SAC? Currently the options that I have is generate records for each existng record such that the table becomes,

ID | DATE | COST

1 | 01/01/2018 - 1 sec| 0

1 | 01/01/2018 | 5

1 | 01/05/2018 - 1 sec | 5

1 | 01/05/2018 | 0

1 | 01/06/2018 - 1 sec | 0

1 | 01/06/2018 | 5

1 | 01/10/2018 - 1 sec | 5

1 | 01/10/2018 | 0

Or

perform join with calendar table and add values for missing dates.

Currently that chart looks like following,