BookmarkSubscribeRSS Feed
JC927
Calcite | Level 5

Hi,

 

I would like to use parameter for the display rule's interval instead of hard coded it because my interval may change depending on data. May I know how can I achieve this? Thanks

4 REPLIES 4
FredrikE
Rhodochrosite | Level 12

Hi!

One way is to create a calculated item that uses your parameter and then create the display rule on that calculated item.

//Fredrik

JC927
Calcite | Level 5

Hi Fredrike,

 

Thanks for you time on my question. But, I would like to have the parameter on the interval eg.(1 >=  <= 5 ; 5 > <= 10 ; 10 > <= 15), those number to parameter, understand that it is not possible but is there any other way to achieve this? Thanks

FredrikE
Rhodochrosite | Level 12

Maybe i am way out here 🙂

but...

 

IF you create a calculated measure that use your parameter or parameters to create a status and then create a display rule on that status, something like this:

 

If [parameter] = '1 >=  <= 5' and (1 <= [value] <=5) then status = 1

else If [parameter] = '5 >=  <= 10' and (5 <= [value] <=10) then status = 1      ***** (or 2 if you want to have different display rules)

else If [parameter] = '10 >=  <= 15' and (10 <= [value] <=15) then status = 1      ***** (or 3 if you want to have different display rules)

 

 

Won't that work fo you?

//Fredrik

 

JC927
Calcite | Level 5

Hi Fredrike,

 

That was a good ideaSmiley Wink but it still not achievable on GAUGE right?

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 4 replies
  • 989 views
  • 0 likes
  • 2 in conversation