topic Re: SAS VA 8.3 Display rule interval using Parameter in SAS Visual Analytics

SAS VA 8.3 Display rule interval using Parameter

JC927 — Fri, 29 Mar 2019 02:22:47 GMT

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

Re: SAS VA 8.3 Display rule interval using Parameter

FredrikE — Fri, 29 Mar 2019 08:40:06 GMT

Hi!

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

//Fredrik

Re: SAS VA 8.3 Display rule interval using Parameter

JC927 — Fri, 29 Mar 2019 10:03:06 GMT

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

Re: SAS VA 8.3 Display rule interval using Parameter

FredrikE — Mon, 01 Apr 2019 10:50:34 GMT

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

Re: SAS VA 8.3 Display rule interval using Parameter

JC927 — Tue, 02 Apr 2019 01:56:29 GMT

Hi Fredrike,

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