Written by

Bernard Marr

Bernard Marr is a world-renowned futurist, influencer and thought leader in the fields of business and technology, with a passion for using technology for the good of humanity. He is a best-selling author of 20 books, writes a regular column for Forbes and advises and coaches many of the world’s best-known organisations. He has over 2 million social media followers, 1 million newsletter subscribers and was ranked by LinkedIn as one of the top 5 business influencers in the world and the No 1 influencer in the UK.

Bernard’s latest book is ‘Business Trends in Practice: The 25+ Trends That Are Redefining Organisations’

View Latest Book

Follow Me

Bernard Marr ist ein weltbekannter Futurist, Influencer und Vordenker in den Bereichen Wirtschaft und Technologie mit einer Leidenschaft für den Einsatz von Technologie zum Wohle der Menschheit. Er ist Bestsellerautor von 20 Büchern, schreibt eine regelmäßige Kolumne für Forbes und berät und coacht viele der weltweit bekanntesten Organisationen. Er hat über 2 Millionen Social-Media-Follower, 1 Million Newsletter-Abonnenten und wurde von LinkedIn als einer der Top-5-Business-Influencer der Welt und von Xing als Top Mind 2021 ausgezeichnet.

Bernards neueste Bücher sind ‘Künstliche Intelligenz im Unternehmen: Innovative Anwendungen in 50 Erfolgreichen Unternehmen’

View Latest Book

Follow Me

Performance Reporting: How To Use Traffic Light Colours And RAG Ratings in Dashboards

2 July 2021

In performance reporting terms, the traffic light rating acts as a visual indicator of performance. Also known as RAG (because of the red, amber and green colours), traffic light icons are commonly used in dashboards and other kinds of performance reporting to tell us where performance is on track and where attention is needed.

With such a simple way of presenting information, you might think it’s hard to get it wrong. Unfortunately, that’s not the case. In my experience, traffic light ratings are commonly misused and misinterpreted.

Where companies go wrong with KPI traffic lights

There are three main ways traffic lights are misused in performance reporting. Firstly, what I see most often is massive overuse of traffic lights – whether on a dashboard or in a report, what’s presented is a long list of KPIs with traffic light colours next to them, displaying either red, amber or green. The trouble with listing so many RAG ratings on one page or screen is that people quickly suffer from information overload. If we’re being directed to 50 pieces of information at once, we feel stressed, we find it hard to identify the most important information, and we come away with no valuable insights.

Secondly, because the traffic light colours are seen as so intuitive, companies don’t always take the time to clarify what each of the RAG ratings mean. For example, when you see an amber icon, does that mean performance is not great but it’s okay? Or does it mean that attention is required in this area? Or does it act as an early warning that performance might be going off-track? Unless you clearly state the meaning for each colour, the traffic light ratings are open to interpretation.

And thirdly, I’ve learned over the years that people HATE seeing red on a dashboard or in a report when it relates to their area of responsibility. Red puts people on the defensive. They’d rather see green, green and more green. As a result of this instinct, people can be tempted to twist the interpretation of KPIs just so they can get that all-green screen. When you start doing that, performance reporting becomes meaningless. So I always stress to companies that it’s important to strike a balance between red and green in reporting – red shouldn’t be avoided like the plague. Red ratings are a great opportunity to flag up areas that require attention, attract resources where needed and, above all, improve performance.

Using traffic lights effectively in your performance reporting

Having looked at some of the biggest pitfalls of using traffic light colours in performance reporting, let’s look at how to avoid those issues and use traffic lights in a smart, effective and meaningful way. Here are my top tips: 

  • Don’t overuse traffic light colours. RAG ratings are at their most effective when they’re highlighting specific, vital measures. So rather than listing 50 RAG icons on your display, use one or two really carefully so you can draw people’s attention to the most important metrics.
  • Stick with the three RAG colours. I’m seeing more and more companies introduce a yellow colour as well as the amber, which, unless the difference between yellow and amber is crystal clear, is just confusing and pointless. I would always recommend sticking with the core colour conventions of red, amber and green. Occasionally, you might want a fourth colour to highlight where you’re exceeding a target by a long way. If you want to do this, blue is a good colour as it’s sufficiently different from the others.
  • Clearly define the colours. You want everyone viewing the metrics to clearly understand what the colours mean, so be sure to include a definition. Red commonly is used to highlight problem areas, where action is required to turn things around. (But it’s worth stressing to those in the organisation that red is an opportunity more than anything – an opportunity to improve performance.) Amber usually means there are some issues to address in this area. And green is used to show where things are on track.
  • Add symbols as well as RAG colours. There are 2.7 million colour blind people in the UK alone – people who can’t distinguish between red and green. So it’s always worth using symbols as well as colours. A thumb icon works well for this, pointing up (green), down (red) and sideways (amber) as appropriate.
  • Focus on the future, not the present or past. Earlier, I mentioned the temptation to avoid red icons like the plague, even if that means distorting the measurement itself. A neat trick to overcome this problem is to move the timeframe from the present or past into the future. So, instead of using traffic light KPIs to show what’s already happened (last quarter’s sales, for instance), use them as a predictor (i.e. next quarter’s sales). The KPI is no longer a reflection of past performance, which can make people very defensive, but is an indicator of where performance is likely to be in the future, which people are more likely to actively engage with.

Traffic light ratings can be a useful addition to KPI reporting, but only if they’re used carefully, and sparingly! Follow these tips for using traffic light colours effectively and you can better engage people in performance metrics, and help them to improve performance in the future.

Where to go from here

If you would like to know more about KPIs and performance management, check out my articles on:

Or browse the KPI Library to find the metrics that matter most to you.

Business Trends In Practice | Bernard Marr
Business Trends In Practice | Bernard Marr

Related Articles

3 Ways To Reinvent Your Products And Services For The Future

With the rise of the metaverse and web3 technologies, there’s no denying the next evolution of the internet is already underway.[...]

Virtual Influencer Noonoouri Lands Record Deal: Is She The Future Of Music?

Teenage influencer Noonoouri has 400,000 followers on Instagram and has starred in fashion campaigns for Dior, Balenciaga and Valentino.[...]

Managing Stress at Work: 5 Top Tips Anyone Can Follow

In our contemporary world, the pressures of the professional sphere often encroach upon our personal space, giving rise to stress and an overwhelming sense of dread.[...]

6 Roadblocks Stopping Web3 And The Metaverse Becoming A Reality

With the emergence of the metaverse and web3 technologies, it’s clear that the next evolution of the internet is already underway.[...]

The Future Of Factories: 3 Ways To Navigate The Industrial Metaverse

What is the industrial metaverse, you ask? Well, we’re not talking about a separate metaverse exclusively for manufacturers..[...]

The Five Questions Every CEO Must Answer About Sustainability

The future of business is green. As a CEO, the ball is in your court to make sustainability an integral part of your corporate strategy.[...]

Stay up-to-date

  • Get updates straight to your inbox
  • Join my 1 million newsletter subscribers
  • Never miss any new content

Social Media

Yearly Views


View Podcasts