Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to fill empty rows with a formula that decrease in value over time

devalex
5 - Atom

Hello,

 

This is a sample from my data table:

DateProfitLoss
1/1/201110000050000
2/1/2011  
3/1/2011  
4/1/2011  
5/1/2011  
6/1/2011  
7/1/2011  
8/1/2011  
9/1/2011  
10/1/2011  
11/1/2011  
12/1/2011  
1/1/20129000047000
2/1/2012  
3/1/2012  
4/1/2012  
5/1/2012  
6/1/2012  
7/1/2012  
8/1/2012  
9/1/2012  
10/1/2012  
11/1/2012  
12/1/2012  
1/1/20138000041000
2/1/2013  
3/1/2013  
4/1/2013  
5/1/2013  
6/1/2013  
7/1/2013  
8/1/2013  
9/1/2013  
10/1/2013  
11/1/2013  
12/1/2013  
1/1/20147000036000

 

What I am trying to do is fill the empty values of the remaining dates.

The value in the first month for each year is actually the total for the whole year. So, "100,000" profit is profit for the whole year. I am splitting this "100,000" into 12 months to get a prediction of profit by month. However I need assistance in filling all the remaining empty rows in that year so that they decrease over time and do not overlap with the following years first month.


By that I mean that the December month of the prior year should be greater than the first month of the next year. This is to prevent staggering graphics 

 

Staggerd Graph.PNG

Thank you.

2 REPLIES 2
aatalai
13 - Pulsar

@devalex I don't exactly follow but does this help?

devalex
5 - Atom

So I'm trying to have the values decrease progressively by month. In the example you showed they are decreasing but only by year. I need them to decrease incrementally each month. No month should have the same value.

Labels