Rolling last two years (24 months) in script editor

JoannaM — Tue, 07 Sep 2021 08:22:37 GMT

Hi all

I have this:

month	year	pcs
1	2019	500
2	2019	800
3	2019	600
4	2019	900
5	2019	600
6	2019	500
7	2019	300
8	2019	400
9	2019	500
10	2019	600
11	2019	700
12	2019	800
1	2020	900
2	2020	200
3	2020	600
4	2020	500
5	2020	300
6	2020	400
7	2020	500
8	2020	300
9	2020	400
10	2020	500
11	2020	800
12	2020	500
1	2021	300
2	2021	400
3	2021	500
4	2021	600
5	2021	500
6	2021	300
7	2021	400
8	2021	500
9	2021	100
10	2021
11	2021
12	2021

I need to show only the current months and then the last 23 months. Rolling bakwards two years:

10	2019	600
11	2019	700
12	2019	800
1	2020	900
2	2020	200
3	2020	600
4	2020	500
5	2020	300
6	2020	400
7	2020	500
8	2020	300
9	2020	400
10	2020	500
11	2020	800
12	2020	500
1	2021	300
2	2021	400
3	2021	500
4	2021	600
5	2021	500
6	2021	300
7	2021	400
8	2021	500
9	2021	100

Script:

Temp_00:
LOAD *INLINE [
month, year, pcs
1, 2019, 500
2, 2019, 800
3, 2019, 600
4, 2019, 900
5, 2019, 600
6, 2019, 500
7, 2019, 300
8, 2019, 400
9, 2019, 500
10, 2019, 600
11, 2019, 700
12, 2019, 800
1, 2020, 900
2, 2020, 200
3, 2020, 600
4, 2020, 500
5, 2020, 300
6, 2020, 400
7, 2020, 500
8, 2020, 300
9, 2020, 400
10, 2020, 500
11, 2020, 800
12, 2020, 500
1, 2021, 300
2, 2021, 400
3, 2021, 500
4, 2021, 600
5, 2021, 500
6, 2021, 300
7, 2021, 400
8, 2021, 500
9, 2021, 100
10, 2021,
11, 2021,
12, 2021,
];

I would like to do it over script editor. Can anyone help me out?

Thanks a lot.

BR, Joanna

Re: Rolling last two years (24 months) in script editor

AshutoshBhumkar — Tue, 07 Sep 2021 08:57:27 GMT

Hi,

Make dates using data of month year i.e makedate(Year, Month, 1) as Date and then restrict data in the backend or frontend using expression like : >=Addmonths(Date,-24)

Thanks,

Ashutosh

Re: Rolling last two years (24 months) in script editor

JoannaM — Tue, 07 Sep 2021 11:19:53 GMT

Hi Ashutosh

Thank you so much for your help.

It worked: where Date(Floor("store date"),'DD.MM.YYYY')>=Addmonths(today(1),-24)

BR, Joanna

topic Re: Rolling last two years (24 months) in script editor in Visualization and Usability

Rolling last two years (24 months) in script editor

Re: Rolling last two years (24 months) in script editor

Re: Rolling last two years (24 months) in script editor