Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a file with datas for each 6 months. I want to do an analysis for last 3 periods so for the last 18 months.
Can I do this with set analysis? What is the syntax?
Thanks you,
You can do this with Set Analysis, but I would suggest trying simpler (and better) ways first. If you load all your data, and in addition a Master Calendar, you could define a relative month in this calendar: 0 for this month, -1 for last month, etc. All you then need to do is to select month -18 to -1.
See more on Relative Calendar Fields
HIC
Yes You Have an expression but can you upload your data file?
or
Check This Thread
You can do this with Set Analysis, but I would suggest trying simpler (and better) ways first. If you load all your data, and in addition a Master Calendar, you could define a relative month in this calendar: 0 for this month, -1 for last month, etc. All you then need to do is to select month -18 to -1.
See more on Relative Calendar Fields
HIC