Running Total

learnDomo

Hello, I need help.

Wondering why my running total is failing. I have the logic set up in the dataflow. The card returns the the correct value in months where there was production but for months with no activity, the value is skipped but returns the right value in the subsequent period. How do I resolve this?

Product		mon1	mon2	mon3	mon4	mon5	mon6
xxxx	sales	0	6	2	4	3	2
	dbSize	0	6	8	12	15	17
xxxx	sales	1	2	3	3	4	1
	dbSize	1	3	6	9	13	14
xxxx	sales	2	3	3	5	0	7
	dbSize	2	5	8	13	0	20

MarkSnodgrass

In your ETL, before you do your running total in the rank & window tile, you are going to need to join your data to all months that exist. This way, there will be no gaps and you will be able to create a running total for each month.

ArborRose

Consider using coalesce for months with no value. Coalesce lets us get a value such as zero, when the condition is null.

MarkSnodgrass

In your ETL, before you do your running total in the rank & window tile, you are going to need to join your data to all months that exist. This way, there will be no gaps and you will be able to create a running total for each month.

ArborRose

Consider using coalesce for months with no value. Coalesce lets us get a value such as zero, when the condition is null.