SAS VA 8.3 MAXIFS

[RadDaddo]

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

[TeriPatsilaras]

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