Alerts are used to highlight a particular data with respect to some given condition. Alerts are available in charts, icons etc. It is also available in tabular format (Scorecard and Grid).
Note: Alerts are not available for multiple series and in Pie chart.
Standard functionality of alerts includes:
- Alerts on the basis of percentage of the target value (as for “As Percentage of Target”)
We can bind it to cells. Those cells will be taken as the reference to calculate the respective percentage or we can manually enter those target values.
Note: Alert Values option is available in case of Scorecard (it is used to select values for each column, the value may or may not be used to display, rather it is used for alert calculations).
Alerts are implemented at column level i.e. alert conditions are same for the entire column.
2. Alerts can be taken on the basis of the respective value (on each cell). Here the alert Ranges are taken as reference i.e. Range Min – 30, 30 – 70 and 70 – Max will be taken as target.
Here also the entire Column will hold the same range as conditions.
What if we require different alert range for each cell in a particular column?
Let’s consider the below
Cell 1 – “0-30 Red ; 30-70 Yellow ; 70-Max Green”
Cell 2 – “0-50 Red ; 50-Max Green”
Cell 3 – “0-120 Red ; 120-270 Yellow ; 270-Max Green”
Cell 4 – “0-0.5 Red ; 0.5-Max Green”
Most of the formatting work will be done on the excel.
Xcelsius 2008 SP3 (SAP Crystal Dashboard Design).
Cell level alert calculation is done on the excel side. Suppose we have the below data set.
Our requirement is like we want different range for each cell. Red, Yellow and Green are the colors that we will be using for alerts.
Note: Before we go further let’s have a look on the working of the range set (under alert tab).
Suppose range is defined as 30 (lower limit) – 70 (upper limit). It means all the data that is equal to or greater than 30 and less than 70 are included.
i.e. 30 <= Data < 70.
As per the requirement for Label BB range is “0-50 Red; 50-Max Green” (where as in Xcelsius Range is given as “0-30 Red; 30-70 Yellow; 70-Max Green”). So instead of using the Xcelsius range directly we use the “If” condition to calculate the value (with respect to the actual data), which will fall in the Xcelsius Range.
So for 61 we used logic as =IF(C6<50,29,100)
So after inserting the excel formula cells will look like:
It will look like this: (29, 69 and 100 are taken as reference to keep them inside the range defined in Xcelsius Alerts.)
Excel snapshot will look like:
Step1: Insert a Scorecard component on the design canvas. Map the Data Display with Sheet1!$B$4:$E$8
Step2: Go to the Appearance tab set the Custom Column Widths as:
Step3: Go to the Alerts Tab, Enable Alerts as follows-
Step4: Select Alert Values as Sheet1!$D$5:$D$8 (Column with el formulas). Select By Value radio button.
Step 5: Set the alerts as follows:
Alert Threshold will always depend on the cell with maximum number of range set i.e. if a cell requires 4 color codes to define it correctly use the same number of colors in Xcelsius.
On preview the component will look like:
Note: Only in scorecard we can find two checkboxes under Alert Threshold. With this one can change the appearance of the alert (one can show alerts with the help of icons or with colored cells).
If we select the 2dn checkbox the alert will look like:
Related Blogs :-