How build charts with gap in data?

[vitaliichupryna]

Hi, 

I've qvd with snapshot data, small example:

SnapshotKey	Quantity	Cost	Date
1	10	50	12/17/2018
1	12	60	12/18/2018
2	3	6	12/17/2018
2	8	16	12/18/2018
3	6	6	12/17/2018
4	9	27	12/17/2018

I need build charts that will show how quantity and cost changed by date field. My problem is that snapshot table contains only changes, so for date 12/17/2018 I have data for all keys:

SnapshotKey	Quantity	Cost	SnapShot
1	10	50	12/17/2018
2	3	6	12/17/2018
3	6	6	12/17/2018
4	9	27	12/17/2018
Total	28	89

But for 12/18/2018 only two

SnapshotKey	Quantity	Cost	SnapshotDate
1	12	60	12/18/2018
2	8	16	12/18/2018
Total	20	66

Instead of this I expect to see

SnapshotKey	Quantity	Cost	SnapshotDate
1	12	60	12/18/2018
2	8	16	12/18/2018
3	6	6	12/18/2018
4	9	27	12/18/2018
Total	35	109

Thanks,

Vitalii 

[sunny_talwar · Accepted solution]

May be you need to look here

Generating Missing Data