Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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