MAX, AVG, NON BLANK over list dimensions and YoY Averages (seasonality) for TIME dimensions (2 Q's)
I have a Line Item "Conversion %" in a module that applies to a fake time dimension list called "Aging Days" that ranges from 0 - 365.
0 / 1 / 2 / 3 / 4 // ... // 365
Conversion% 1% / 1.5% / <blank> / <blank> / 1.6% / 1.6% / .... // 26.5%
If you see the above data, it is a curve (cumulative %) over 365 days. Therefore, for several days, the values remain constant. In many cases, it is also blank (in which case we wish to assume previous non blank data).
I am trying to calculate an extrapolated curve that will always have a value (give me the previous non blank value in case there are blanks - but over the "Aging Days" list and not time dimension). In the above example, both the blank values should be filled with 1.5%. Note that there is no control over how many blanks can occur, so using a "Previous Aging Day" list property for the fake time dimension will not help. Adding another line item to CUMULATE over the list doesn't help either.
Also, I wish to have another line item to calculatemax, or average etc if possible, over the "aging days" schedule/list.
Can someone help, please?