Blogs

This Blog

News

Favorite Posts

Archives

ctodx

Discussions, news and rants from the CTO of DevExpress, Julian M Bucknall

Sneak peek: Funnel charts in XtraCharts v2009 vol 2 (ASP.NET / WinForms)

One of a series of posts on the new functionality that'll appear in DXperience v2009 vol 2. This is all pre-beta stuff, we're probably something like a month from beta.

This time, let's look at the new funnel chart in XtraCharts, for both ASP.NET and WinForms. A funnel chart is a weird beast indeed, one of those charts that has a quick visual hit resulting in a rapid understanding of the data, but one that is difficult to estimate the actual values. I'd have to say that labels are required for this type of chart, because we all have difficultly guessing the area of a shape.

(This is just like bubble charts, by the way, where the "third value" of a chart point is the area of a circle at that point. The chart is instantly understandable, yet we have difficultly in assessing the area of the circle at a single point, or even the ratio of the areas of two points on the chart. We should show the values as labels.)

image

Here's a simple funnel chart. Unlike a pie chart, for example, the numbers are not supposed to add up to 100% or anything like that. It's supposed to show the decreasing values about some information set as we add more and more specificity to the data we're sampling. If you like we're showing the trends in a set of data from some process or workflow.

So, for instance, in this graph, we looking at the visitors to a fictitious web site that operates in the same way as ours. So the top band is the total number of visitors. From that set of data, we count the number of visitors who downloaded a trial and get the second band. Obviously this is less than the number in the first band, so we show this intuitively by the sloping lines (the start of the funnel shape, if you like). Of those visitors, a certain number used the support services of the web site — but not all — giving us the third band. Of these, a lesser number bought the product (fourth band) and of these, a smaller number eventually renewed (fifth band). And we're done.

Notice how this set of data produced a pretty good funnel (OK, we cheated on the numbers to make it so), but other data might produce a funnel nearer in shape to a vertical column, whereas other data might be more like a martini glass.

Nevertheless the band are all equal in height, in order to give the end-user a better chance to estimate the data values — in essence the average width of the band. But, it's still better to show the labels (we provide several locations for the labels: right (as shown), left, center, or left/right as a column). The data above is shown in absolute units, but you can also show it as percentages, which for such a chart may be a better alternative.

Published May 29 2009, 03:25 PM by
Filed under: , ,
Bookmark and Share

Comments

Dennis Sourvanos

That can be very usufull in software where you study the earth's age, or trees etc

May 29, 2009 8:10 PM

Michael Proctor

I will also be using it for a sales report to show, Quotes, Orders, Sales

for each sale you should have another 3 orders to have 3 orders you should have 10 quotes (based on a 1/3 closure rate) if this month or next will be very lean.

If the funnel comes out not looking like a funnel then they will get an immediate visual aid to say that they haven't been working their sales properly.

Look forward to it

May 30, 2009 2:45 AM

Bruno Cossi

This will be very useful for any business intelligence solution - I was hoping the funnel charts would be added, well done!

May 30, 2009 8:55 AM

Luke Grews

At last the wait is over, almost :)!

May 31, 2009 5:39 AM

Luke Grews

At last the wait is over, almost :)!

May 31, 2009 5:39 AM

Saif Khan

It looks like a squnnel though, with sharp edges. I like the round stuff ;)

June 1, 2009 12:22 PM

André Litfin

That's what I'm waiting for - we are developers of a bi app, so we need it :-)

June 5, 2009 2:42 AM

ctodx

One of a series of posts on the new functionality that'll appear in DXperience v2009 vol 2. This

June 23, 2009 7:14 PM

About Julian Bucknall (DevExpress)

Julian is the Chief Technology Officer at Developer Express. You can reach him directly at julianb@devexpress.com. You can also follow him on Twitter with the ID JMBucknall.
LIVE CHAT

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

FOLLOW US

DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2014 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners