BookmarkSubscribeRSS Feed
Federicoconti01
Calcite | Level 5

the problem:

If the user selects only one element as a filter, a calculation must be made on the table, otherwise if he selects no element or more than one, another calculated field is created.

I tried to solve:
     1. I created a field that calculates the number of selected elements.
      2. I created an if else:
          IF ( 'count_days'n = 1 )
          RETURN 1
          ELSE 0

I would like to create a parameter on the value of this calculated field to use on my main table

                      

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 0 replies
  • 1291 views
  • 1 like
  • 1 in conversation