topic Re: unexpected behavior year_to_date function? in SAS Visual Analytics

unexpected behavior year_to_date function?

JPinkman — Thu, 19 Feb 2015 10:55:48 GMT

Hi all,

Been experimenting with this function a bit on a data set, containinig several rules per date. There's 12 dates per year, one for each month. In the report these lines are aggregated automatically . Somehow the ytd function works as expected for only the first to months of each year.

Does anybody have an idea why this is happening?

Thanks

Re: unexpected behavior year_to_date function?

WouterHordijk — Thu, 19 Feb 2015 15:17:53 GMT

There is a parameter in the Year to Date aggregation that is set to "_ToToday_" by default. As a result, the Year to Date function only computes the cumulative sum up until February 19th (today's date) for each year. Edit the aggregated measure and set this parameter to "_Full_" if you wish the Year to Date function to compute the cumulative sum throughout the entire year.

Re: unexpected behavior year_to_date function?

JPinkman — Thu, 26 Mar 2015 13:09:16 GMT

Thanks!