Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Help with Aggregated Measure

Accepted Solution Solved
Reply
Contributor
Posts: 47
Accepted Solution

Help with Aggregated Measure

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


Accepted Solutions
Solution
‎12-21-2015 07:13 PM
Occasional Contributor
Posts: 19

Re: Help with Aggregated Measure

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


SAS Example 12-21-15.JPG

View solution in original post


All Replies
Solution
‎12-21-2015 07:13 PM
Occasional Contributor
Posts: 19

Re: Help with Aggregated Measure

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


SAS Example 12-21-15.JPG
Contributor
Posts: 47

Re: Help with Aggregated Measure

Hi Mike,

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

Re: Help with Aggregated Measure

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

Contributor
Posts: 47

Re: Help with Aggregated Measure

Hi Mike, yep all good, your solution worked. It was my error :-)
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 474 views
  • 1 like
  • 2 in conversation