BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sas_viclearner
Fluorite | Level 6

Hi Team,

I have a hierarchy(Name: ABC) created for 3 variables.

I need to create a drillable crosstab visualisation showing the x, y, z measures by hierarchy ABC.

 

How can I create a display rule which highlights the values( for example greater than 50 as Excellent and less than 50 as poor).

1 ACCEPTED SOLUTION

Accepted Solutions
alineagostini
Obsidian | Level 7

Before I forget, you are also allowed to create alerts in order to send messages to people who want to know whether an indicator has reached its goal or not. You can configure it in the "alert options" sheet.

Personally, I don't know if it's possible to create text alerts instead of using color alerts but through this option, you can add a personalized message saying GOOD or BAD for each of your defined rules.

View solution in original post

4 REPLIES 4
alineagostini
Obsidian | Level 7

Hi,

If I understood well your idea, this is what you should do:

 

1) Create a cross-table and add your hierarchy and the measures to it;

 

H1.PNG


2) Go to the Display Rules panel and add a NEW rule (sorry mine is in French, then consider NOUVEAU);

 

Nrule.PNG

 

3) Select the variable (or all variables) which contain the value that you want to use to create the display rules (they are not necessarily the same in which you will apply the rules (read the item 7);

4) Select the operator (for example <=);
5) Select the value (for example 50);
6) Now you have to choose a new style to it (for example, change the background color to red);

7) Pick the variable (or all variables) in which you want the rules to be applied and you will see the results in your crosstab just after your OK;

 

R2.PNG


😎 If that is what you were looking for, you can add a new rule, change the operator to >, keep 50 as value but change the color to green (here I did the green first :));

 

R3.PNG

H3.PNG

 

R4.PNG

 

H4.PNG

 

Hope it helps!

alineagostini
Obsidian | Level 7

Before I forget, you are also allowed to create alerts in order to send messages to people who want to know whether an indicator has reached its goal or not. You can configure it in the "alert options" sheet.

Personally, I don't know if it's possible to create text alerts instead of using color alerts but through this option, you can add a personalized message saying GOOD or BAD for each of your defined rules.

sas_viclearner
Fluorite | Level 6

how can i add a personalized message for scores <50 as poor and >50 as excellent

alineagostini
Obsidian | Level 7

Hello,

I am glad the first part of the answer has helped you but I think I made a mistake. Actually, I find you are not allowed to send a personalized written message by the alerts option (and in this case, I have assumpted that it was possible to write a message as we can do in the distribution option but I was wrong :().

Anyway, what you can do is set your alert like this:


1) Go to the Subscription and Notification sheet;
2) Check the box "create an alert based on this rule";
3) + Add one or more subscribers (pick them from the left list - if you don't see a list, contact your admin) and transfer them to the right pane;
4) In the second sheet (you will see a little man and a clock) you can add a name to show, an identifier and if you want you can add other subscribers.

After saving your report, if your rule is met, the subscribers will receive a message like this:


SAS Alert: A metric condition has been met


A metric condition has been met for <Name of your table> in the <Name of your report>
"M1" < 50

Click on the link to see the object or changing your parameters:
<Link to your report>


I personally couldn't find a way to add a message to the alert but I suggest you read the links below:

 

http://support.sas.com/kb/53/757.html 

https://communities.sas.com/t5/SAS-Visual-Analytics/quot-Alert-quot-function-in-SAS-VA/m-p/193350/hi...

https://communities.sas.com/t5/SAS-Visual-Analytics/Alert-Based-Email/m-p/202155/highlight/true#M181...

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1478 views
  • 0 likes
  • 2 in conversation