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

Alert Based Email

Reply
Regular Contributor
Posts: 196

Alert Based Email

Hi All,

Present I am working on VA 7.1, is there any way to send percent based emails, let us suppose ..

I have data like this

E-Name      Target          Actual             Achvt%           email id    

X                    200               200                    100%             x@abc.com

Y                    100               23                         23%            y@abc.com

Z                      200             100                      50%             z@abc.com


is there any way to send alert or Email who's achvt is below 60%.


X acvt is 100% so i want to send email or alert except X.


Is there anyway to achieve this...

Thanks.

Teja Surapaneni



    

SAS Employee
Posts: 9

Re: Alert Based Email

Hi Teja Surapaneni,

In Visual Analytics, click on Report Designer. I will be using the data you have provided above as an example. Therefore, in Designer I would create a list table with E-Name, Target, Actual, Achvt%, and Email ID as column headers. Then, on the right side there are a list of tabs including Properties, Styles, and Display Rules. Click on the drop down arrow that will state List of Tabs when you highlight over it. Here, click on Alerts, then click on new alert. In the Expression tab, customize your alert to have the Column as Achvt%, Operator as <, and Value as 60. In the Subscription and Notification tab, click the plus sign to add registered users that would receive the alerts if Achvt% for any row is below sixty percent. However, you can only send the alert to a registered user in the system, in which their email will be linked to their name. Therefore, when X and Y are below sixty percent, any subscribed user will be notified. In addition, you can control how many notifications are to be sent to the subscribers per minute, hour, and day. Please let me know if you have any more questions!

Thank you,

Meredith Bailey

Regular Contributor
Posts: 196

Re: Alert Based Email

Hello Bailey,    

Thanks for response,

E-Name      Target          Actual             Achvt%           email id   

X                    200               200                    100%             x@abc.com

Y                    100               23                         23%            y@abc.com

Z                      200             100                      70%             z@abc.com

You are saying that if any employee is doing below 60%, The mail(alert) will sent to all registered employees, But i want to sent only that particular empl. who is doing below 60%. from the above example i want to send alert  only for Y and it should be automated.

Thanks,

Teja Surapaneni.

SAS Employee
Posts: 9

Re: Alert Based Email

Hi Teja Surapaneni,


Yes, if one employee in particular is below sixty percent, the alert will be sent to all registered users who are subscribed to the alerts. Unfortunately, there is no way to only send an alert to that specific employee who is below sixty percent.

Thank you,

Meredith Bailey

Ask a Question
Discussion stats
  • 3 replies
  • 469 views
  • 0 likes
  • 2 in conversation