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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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