2023 Week 23 | Sales Funnels

Introduction

There are a lot of visualisation common practises that are less than ideal. One of those is the funnel chart. I think the analogy works well, however a lot of implementations are misleading at best. Unfortunately the default funnel chart in CRMA belongs in that category. As the value is only encoded in the height of a layer and not in the width, it’s quite hard to visually understand if a stage is smaller or bigger than the previous one.

Here are a few alternatives! The first one is the actual challenge, the other three are for comparison to see what comparison each of them actually allows for.

Requirements

• Create a recipe that transforms the data in a format that allows you to create the below dashboard
•  Create a custom funnel chart
  • Each bar should be centred in the widget
  • Ignore all closed stages
  • Each bar should be appropriately sized in relation to all other bars (ie. a 1000$ bar should be twice as long as a 500$ bar)
  • The bars should be ordered by stages
  • The value of all opportunities in each stage should be displayed next to the stage name
  • Remove the axis
• For reference
  • Create a normal bar chart, a default funnel and a stacked bar chart
• Colour all of them in the same colours (You can find them here!)

Optional:

• Compare the different charts and consider what advantages/disadvantages each of them has. If you want, let me know on Twitter or LinkedIn what you think

The resulting dashboard should look something like this: