This visualization is not only one of the cleanest tables we have seen, it is also one of the most innovative. Check out the sort feature at the bottom- it moves column by column to sort the visualization. Read how to do this yourself below.
About this Viz
Craig achieved this sort capability through an interesting work around. First, he added seven columns to his excel database (one for Name, one for Office, etc) and assigned a distinct value for each row and sort. For example, Abercrombie, Neil has a value of 1 in the Name Sort column, but a value of 13 for District Sort (HI-01). Then, Craig created a parameter that you see on the dashboard in the bottom left as "Choose Sort Order By". After creating a calculated field, he used the Case function to specify which "sort" column would be active at any one time. Then all he needed to do was put that calculated field into the worksheet and sort the Name field by it.
Quite a task, but we think you will agree the result is fantastic. Download the workbook to see the inner workings for yourself.
Note: Our apologies for having to resize this visualization to fit on our blog.
“Take the Excel charting engine, make it a standalone app that can chart data from any source, and give it a web/community sharing component for publishing charts and dashboards on the web. Except this charting engine is light years ahead of Excel in terms of both its capabilities as well as ease of use.”
