topic Re: Help with Aggregated Measure in SAS Visual Analytics

Help with Aggregated Measure

Haydn — Mon, 21 Dec 2015 21:21:07 GMT

Hi,

I have a Category called "Current" with values of "Y" and "N". I have a measure called "Unique". Is it possible in SAS VA to create a New Aggregated Measure, by only have the value of "Current" being "Y" and returning the measure "Unique" where this condition has been met?

Cheers

Haydn

Re: Help with Aggregated Measure

SAS_Mike — Mon, 21 Dec 2015 23:39:10 GMT

Hello Haydn,

I think I accomplished what you are looking for using a calculated item instead of aggregated measure. Please take a look at the image I am attaching.

If( Current = "Y")

Return Measure

Else ""

Leave else blank and it should interpret it as blank/return nothing.

Let me know if that doesn't work.

Mike

Re: Help with Aggregated Measure

Haydn — Mon, 21 Dec 2015 23:52:07 GMT

Hi Mike,

Thanks for you reply. I tried your solution and under messages it shows up as, "Conversion required from: Character to: Numeric

Re: Help with Aggregated Measure

SAS_Mike — Tue, 22 Dec 2015 00:16:27 GMT

Hi Haydn,

It looks like you marked my response as accepted. If you are having any trouble still let me know. Perhaps include a screenshot if possible? I think it was probably an error with the quotation marks.

Thanks,

Michael

Re: Help with Aggregated Measure

Haydn — Tue, 22 Dec 2015 00:17:33 GMT

Hi Mike, yep all good, your solution worked. It was my error 🙂