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

How to create a measure based on category value (SAS VA 7.4)

Reply
Frequent Learner
Posts: 1

How to create a measure based on category value (SAS VA 7.4)

Hi,

I want to create a new measure, which is based on the value of a category.

For example:

New measure "Number of answered calls", should count (or sum) when the category value is A, else 0. 

Category value  Count as call?

         A                       Yes

         B                       No

         C                       No

         A                       Yes

 

When I try to create an function SAS VA states (have tried with IF and In etc.)

Type mismatch: expected type of at this location is Boolean, type of item being applied is Character

 

In Tableau I was able to use relatively simple sql statements, but cannot do this in SAS VA.

Am I missing something obvious or do we need to do these calculations before the data is uploaded to SAS VA?

Hope to recieve some help from you ;-)

Best Regards Martin

Ask a Question
Discussion stats
  • 0 replies
  • 44 views
  • 0 likes
  • 1 in conversation