Function RelativePeriod - convert result and insert parameter

KOKIUSMAT — Wed, 16 Nov 2022 19:51:06 GMT

HI,

I want to convert in a String variable the number variable that is result of a difference between two period calculated with function RelativePeriod .

Example: 1 = "positive" ; -1 = "negative" etc

But it's not possible because it is a aggregate calculated. Is there a solution?

Then I want to insert a parameter in the "offset interval" but it accepts only numbers. Is there a solution?

Thanks

Re: Function RelativePeriod - convert result and insert parameter

Sam_SAS — Wed, 16 Nov 2022 21:20:04 GMT

Hello,

I don't think you can make the output of RelativePeriod into a string, sorry.

For what it is worth, you can apply display rules to aggregated measure values. So you could highlight the positive/negative differences.

A workaround that is sometimes suggested when working with aggregated values is to create an aggregated data source to store the aggregated values.

For the offset parameter, I believe you could do something very inelegant like this:

IF ( 'Param'p = 1 )
RETURN <RelativePeriod expression with offset 1>
ELSE IF ('Param'p =2 )

RETURN <RelativePeriod expression with offset 2>

ELSE IF ('Param'p =3 )

RETURN <RelativePeriod expression with offset 3>

And so on.

You could give it a try.

Let us know if that helps.

Thanks,

Sam

topic Re: Function RelativePeriod - convert result and insert parameter in SAS Visual Analytics

Function RelativePeriod - convert result and insert parameter

Re: Function RelativePeriod - convert result and insert parameter