Conditional formatting for Tables (SAP Analytics Cloud)

by Bala | Analytics , SAP , SAP Analytics Cloud ,

Tables are an effective way of displaying data. Highlighting important values or providing visual cues in a table enables user engagement and helps make faster decisions. This is where conditional formatting comes into play. Conditional formatting uses thresholds to provide visual cues of your information, so that you can quickly see which areas are doing well, and which areas may need improvements. When you apply conditional formatting in SAP Analytics Cloud,

• You can use multiple ranges, and you can change the label names and colors.
• When you enter the value for your range, the value appears on the line at the bottom of the panel. The value includes a letter to designate whether it is thousands, millions, and so on.
• You do not need to set both an upper and a lower bound if you have only one range. When you add more ranges, you can leave either the upper or lower bound empty.

In this blog, we are going to see how to add conditional formatting to a Table in SAP analytics Cloud (SAC)

1.Goto SAP Analytics cloud in the browser and click on create story.

2.Click on the “Add a Canvas Page”.

3.Add a data source (Model) and click OK.

4. Now add a table and select required dimensions and measures (in this example City and Salary are chosen)

5.Now click on  “More” and select “Conditional Formatting”.

6.Now choose a measure that needs formatting (Salary is chosen here).

7.Choose a comparative measure listed in the drop down.

There will be two options.

1. Number Range (Static): In this a number range can be give for comparison (Ex: >120 or <200)
2. Measure (Dynamic): This is used when the values has to be compared with another measure in the data source.

In this example Number Range is selected.

8. Under Ranges, set a lower and upper boundaries.

As we type our values for the upper and lower, we consider giving values which are certain.

For example, A lower boundary cannot be larger than the upper.

9.To add another range, select Add Range.

There is an option at the bottom (next to “Add Range” option)  to filter out data if needed.

10.When finished with the adding thresholds, click Apply.

11.Select DONE

12.When we click on “Done”, the formatting will not be applied to the table. There is one more step to be done to apply the formatting.

Click on the Column, goto Thresholds àclick on ” Show thresholds ”

(Formatting has been applied)

 

13. By default we will see the colors set by SAC. To change those to the colors we created click on the “More” and select the required colour and Click on apply.

Now that the conditional formatting for the table is done, we can easily focus on the high and low data points.