BookmarkSubscribeRSS Feed
RadDaddo
Fluorite | Level 6

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

1 REPLY 1
TeriPatsilaras
SAS Employee

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

Teri Patsilaras is a Senior Manager in the Global Enablement and Learning (GEL) Team within SAS R&D's Technology Transfer and Governance Division

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 822 views
  • 0 likes
  • 2 in conversation