So here the scenario is, I have to get the dates for 24 months of period for a sales report and it should be automated. Suppose I should a time period from 1/4/2017 to 1/4/2018 but when it comes to the 25th month, the start date of 1st month should also be changed, so that I would get results for only 24 months.
Should I go for YTD or anything else?
And it should be in the scripting, not in front end.
you want to limit your data to the last 24 months in the Script or in a specific chart using an expression ?
if you limit in the script: in all your app you will only have two years of data.
if you limit on a chart using an expression: you will have all the data from the source, the limitation will be applied only on a specific chart. so if you need to analyze data before the last two years, it will be possible