topic SAS VA 8.3 MAXIFS in SAS Visual Analytics

SAS VA 8.3 MAXIFS

RadDaddo — Thu, 12 Sep 2019 17:40:43 GMT

Hi,

Does anyone know how to create a calculation within SAS Visual Analytics that results in a "MAXIFS" function (c.f. Excel)? For instance, the maximum date if/ when a minimum number/ threshold of transactions is completed. I also need to be able to filter by this date. In some cases, I also need to do the same but for week # instead of date.

Thank-you,

Leslie

Re: SAS VA 8.3 MAXIFS

TeriPatsilaras — Fri, 13 Sep 2019 16:38:51 GMT

Hi Leslie,

It sounds like you are running into our nested aggregated measure limitation. Check out my blogs on how to use an aggregated data source to work around this:

VA 8.3 Aggregated Data Source, an answer to nested aggregated measures and faster reports!

VA Report Example: Number of Days Profitable for the last 30 days

Thank you,

Teri