topic SAS VA 8.3 - Filter and display data that is 6 months or older in SAS Visual Analytics

SAS VA 8.3 - Filter and display data that is 6 months or older

tweehh — Thu, 01 Jul 2021 01:28:39 GMT

Hi!

I am trying to filter and display the tickets that are 6 months or older since the date those tickets were opened. Any ideas how to do this? Any help would be appreciated!

Re: SAS VA 8.3 - Filter and display data that is 6 months or older

Sam_SAS — Tue, 06 Jul 2021 17:58:31 GMT

Hello,

I believe this should be possible but a bit annoying to do.

You can perform math on dates by using the TreatAs operator and remembering that the date values are the number of days since 01JAN1960 (in this case, we don't care when day zero was.)

You can use an expression like this to determine the 'age' of a date value:

TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n)

Then you could compare this number to 180 to approximate a six month cutoff.

So your advanced filter expression would look something like this:

( TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n) ) >= 180

Let us know if that works,

Sam

Re: SAS VA 8.3 - Filter and display data that is 6 months or older

tweehh — Tue, 06 Jul 2021 20:32:04 GMT

Thank you for your response!

I created the first filter (see below) on the report but the results are negative.

TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_,
'Opened at (Date)'n)

Re: SAS VA 8.3 - Filter and display data that is 6 months or older

Sam_SAS — Tue, 06 Jul 2021 20:44:02 GMT

It's a bit unusual that your data item has parentheses in the name. I'm not sure if that could be an issue, or possibly the Opened At column is a datetime value, in which case wrapping in the DatePart() operator should yield the desired result.

Re: SAS VA 8.3 - Filter and display data that is 6 months or older

Sam_SAS — Wed, 07 Jul 2021 13:30:26 GMT

The other issue I forgot to mention is that if you make this a calculated item, you need to set an aggregation other than Sum. That is probably why you are getting such large values.