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.
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.
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)