topic Re: Changing a Parallel Period Date to Today - 1 (Yesterday Date) in SAS Visual Analytics

Changing a Parallel Period Date to Today - 1 (Yesterday Date)

PaulEveleigh — Thu, 04 Jun 2015 05:59:53 GMT

Hi,

I am trying to choose yesterdays date as the preferred end of period when using the Parallel Period option - I only get the option of Today, Full or a specific date..

Anyone have any idea on how to modify it to show Today - 1 (yesterday)

Many thanks

Pail

Re: Changing a Parallel Period Date to Today - 1 (Yesterday Date)

Sam_SAS — Thu, 04 Jun 2015 13:48:41 GMT

Hi Paul,

You could select yesterday's date with the _ToDate_ option, but you would have to update the hardcoded value each day you view the report.

I don't think it is possible otherwise. I'll let the development team know that users are interested in a "_Yesterday_" option.

Thanks,

Sam

Re: Changing a Parallel Period Date to Today - 1 (Yesterday Date)

avvy — Fri, 05 Jun 2015 04:53:53 GMT

Hi Paul,

That would be really great if the option comes up in future release.

I would also like to request you to kindly let the development team know to not only put the "_Yesterday_" option but also give the user frriendly option to user, so that they could be able to drag and drop a "calculated date".

Suppose a developer has to make a parallel period of 3 days prior to present date. He/She can calculate required date and drag that calculated item in the option.

Regards,

Abhishek

Re: Changing a Parallel Period Date to Today - 1 (Yesterday Date)

RR28 — Sun, 07 Jun 2015 19:10:17 GMT

Hi,

Maybe the solution could be creating a new calculated measure "SalesValue1" with "0" value for "Today" date in the past (or other desired [or calculated] date) - using IF .... ELSE.

With this measure even sum with 'Today' should give right result as for 'Yesterday'?

Robert R

Re: Changing a Parallel Period Date to Today - 1 (Yesterday Date)

PaulEveleigh — Tue, 09 Jun 2015 23:08:26 GMT

Thank you Robert - that solved our issue!

Regards

Paul