Skip to Content
Author's profile photo Ingo Hilgefort

Conditional Formatting in SAP BusinessObjects Cloud

Some of you might have seen my previous blog posts sharing the steps on how you could use a Google Sheets in combination with Cloud for Analytics (C4A) and how you could use the data in combination with maps.

 

This time I wanted to setup some conditional formatting as part of my charts.

 

I did start with a simple chart displaying the Revenue across twelve month.

 

C4A_March_24_003.jpg

As next step I wanted to setup some rules – for example comparing the actual revenue with the forecast and based on the target achievement I was going to color code the column in the chart – but then I noticed that there is no conditional formatting for charts at this point in C4A.

 

The I did find the option to add a reference line, which was the closest option to what I was looking for.

 

C4A_March_24_002.jpg

 

 

Using the Reference Line option, you can choose between a Fixed or a Dynamic Reference Line. In my example I selected the dynamic reference line and I selected the Revenue as base for the reference line. You can then choose the aggregation – Max, Min, Average – and you can then configure the color for the area above and below the reference line (shown above).

 

Even though the reference line wasn’t 100% of what I was looking for, I am sure that it will be helpful in other scenarios.

 

Additions to my wishlist for C4A:

 

  • Ability to define conditional formatting for charts
  • Ability to define conditional formatting based on measure comparisons (Actual Revenue vs Forecast)

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Ability to define conditional formatting based on measure comparisons (Actual Revenue vs Forecast)

      Hey, I`m needing this functionality for a customer request. Anyone who could do this by now ?