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-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 427 views
  • 0 likes
  • 2 in conversation