topic Re: SAS VA - How to create aggregated measure by column value in SAS Visual Analytics

SAS VA - How to create aggregated measure by column value

HugoVini — Sat, 06 Apr 2019 21:59:39 GMT

Hello community, I'm having a lot of trouble finding the solution to my problem, I hope you can help me

I have a table that was created from a union, example:

ID RECEIVED PAID REFERENCE

0 100 50 1

1 200 60 1

2 300 70 1

3 400 80 2

4 500 90 2

I'd like to create an aggregated measure that takes all RECEIVED values that have reference equal 1, and another measure for equal reference 2. I've tried several ways to get these measures but I did not succeed.

Thanks in advanced.

Re: SAS VA - How to create aggregated measure by column value

FredrikE — Mon, 08 Apr 2019 06:04:38 GMT

Hi!

Two calculated measure might do it?

[measure1]

IF reference = 1 then recieved

ELSE .

[measure2]

IF reference = 2 then recieved

ELSE .

//Fredrik

Re: SAS VA - How to create aggregated measure by column value

HugoVini — Tue, 09 Apr 2019 01:35:18 GMT

Thanks a lot bro!