BookmarkSubscribeRSS Feed
MahRaz
Fluorite | Level 6

Hi dear members!

 

My objective is to Filter a "Gauge" object in a way to show a measure only for the most recent date available in the data. The filter need to be dynamic as the data will get updated every few days.

 

Problem is that Max operator is not available for Filtering. Do you have any idea how I can do this?

 

Thank you in advance!

Mahraz

5 REPLIES 5
TejaSurapaneni
Lapis Lazuli | Level 10

Hello Mahraz,

 

In present versions (to 7.3) we don't have any option to get Max date (or As on date Values).., This is the most basic requirement........

 

The best way is that you have to Calculate Max date  in your backend data.

 

after loading the data in VA environment put a condition (Calculated).

 

i.e.,

 

If date = Max date

Return (Your measure)

else (.).

 

You will get Max date or As on date value and it is dynamic.

 

Hope this helps..,

 

 

 

Thanks & Regards,

Teja Surapaneni

MahRaz
Fluorite | Level 6

Thank you Teja! It is helpful to know there is no standard way

 

Sam_SAS
SAS Employee
Hello Mahraz,

As Teja says, there is not an easy way to do this currently. Many customers have requested this, so the development team is aware of the demand.

Thanks,
Sam
daviddavid
Fluorite | Level 6

Any update on this question? Important feature!

 

Work-arounds such as rank is really suboptimal

( http://blogs.sas.com/content/sgf/2016/10/24/use-rank-in-sas-visual-analytics-to-display-the-last-dat... )

Sam_SAS
SAS Employee

Hello David,

 

There is a new feature in 7.4 that might be helpful.

 

In 7.4, you can create a slider prompt with a date assigned to it, then on the Properties tab you can set Value=Single and Set value to dynamic maximum. This will dynamically select the latest value for the date data item.

 

slider.png

 

Is that helpful?

 

Thanks,

Sam

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 5 replies
  • 3775 views
  • 5 likes
  • 4 in conversation