topic 7 Months Filter in SAS Visual Analytics

7 Months Filter

Kamohelo — Wed, 07 Jul 2021 13:00:39 GMT

I would like to display 7 months data on a crosstab (Current month and 6 months prior).

Is there any suggestions i can use to achieve this?

Regards

Sam_SAS — Wed, 07 Jul 2021 13:39:05 GMT

You could use an advanced filter expression like this:

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

This selects the last 210 days of rows. I'm not sure if you can make a filter that selects on months intelligently that would span years.

Sam

Kamohelo — Wed, 07 Jul 2021 13:51:34 GMT

Hi Sam,

Thank you - It worked.

Kamo