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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 563 views
  • 0 likes
  • 2 in conversation