running total next 12 months (inventory stock)

Hi!

I have read a lot of post regarding 12 rolling for the previous 12 months but none whatsoever regarding the next 12 months.

I would like to create a running total /moving total that sums the next 12 month all the time.

Like the window sum does in tableau.

I hope you can help!!

Example

Datasets

Developer

Preparation

Data Investigation

Time Series

Accepted answers

SeanAdams

I addition to what folk have mentioned below - you can also do a time-series forecast since this is time-series data.

Well worth looking at the single-tool examples under help / sample workflows; or google for videos like this one: https://www.youtube.com/watch?v=abBzvDijEnM

The benefit of doing this with time-series is that there may be true seasonality in your data (e.g. every summer there are more holiday bookings) and time-series analysis takes this into account.

All comments

pedrodrfaria

Hi @Kk_larsen

Using the Multirow you can create a calculation with the 12 rows below.

Please see attached for the workflow:

Pedro.

running total next 12 months (inventory stock).yxmd

messi007

@Kk_larsen,

Please see below:

Attached the workflow,

Hope this helps,

Regards

SUM_20210224.yxmd

Kk_larsen

That makes sense! Thanks alot @messi007 and @pedrodrfaria

I have 1 additional question. I want to translate this equation from tableau: WINDOW_SUM(ABS(SUM(if [Type] = "Demand" then [Quantity] else 0 END)), 1, 12)

Is it still possible using the multi row formula?

Qiu

@Kk_larsen
Made something that you can calculate the running total for any amount months by changing one location in the workflow.

0224-Kk_larsen.yxzp

SeanAdams

I addition to what folk have mentioned below - you can also do a time-series forecast since this is time-series data.

Well worth looking at the single-tool examples under help / sample workflows; or google for videos like this one: https://www.youtube.com/watch?v=abBzvDijEnM

The benefit of doing this with time-series is that there may be true seasonality in your data (e.g. every summer there are more holiday bookings) and time-series analysis takes this into account.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703