Tuesday, March 29, 2011

Print Test

This is an example about printing. The premise here is that you devote one sheet/dashboard to filtering criteria, and a second to the printing output. In the example below, the selection sheet also has boxes to fill in various comments - these will show up on the printed version. The second tab below is a well-formatted dashboard which is set to print to letter portrait mode.

I find some of these techniques to be annoying - too much tabbing and too much "I need to know how to navigate a priori" - perhaps I am just complaining. It's not that hard I guess. Also, this viz breaks my rule about creating small vizes in 2011 (the goal was to print a letter portrait dashboard however) Anyhoo, a work in progress.

Friday, March 25, 2011

The Outer Limits

There is nothing wrong with your visualization. Do not attempt to adjust the picture. We control the horizontal. We control the vertical...

On the first viz shown below, we calculate the quadrants of the latitudes and longitudes in order to provide geographic 'slicing' filters. On the second viz shown below, we also created percentile calculations to provide additional filters based upon the individual latitudes and longitudes - essentially, this creates the effect of providing axis range sliders.

The only requirement here is that your latitudes and longitudes must A) exist as actual fields (as opposed to using Tableau's built-in geocoding) and B), must be aggregate, e.g. AVG(latitude or longitude). Thus, your level of detail will affect the construction of this example.

Hopefully I won't get in trouble for stealing the outer limits logo. I mean, geesh, it's almost fifty years old at this point.

Thursday, March 24, 2011

TfL Live London Traffic Cameras

I was poking around tfl.gov.uk and noticed that they have images rendered for approximately 180 traffic spots around London. What is nifty is that it appears that the JPG image names do not change over time. Which means I was able to grab their XML file, convert using excel, and create this dashboard. Not much else going on here, except some nice custom shapes. Lovely stuff, this. Quite...

Tuesday, March 22, 2011

Table Calcs and Parameters

I continue to be a huge fan of Tableau Table Calculations in conjunction with Tableau Parameters. In the example below, someone wanted to have a single visual with multiple possible "percent of total" calculations. But, they didn't want to have multiple measurements in play.

Because each Table Calculation can have its own "scope" or "partition" this turns out to be pretty easy to create. Enjoy!

Thursday, March 3, 2011

Changing Viz Types with Dashboard Containers and Parameters

At the heart of this example is the use of two items: 1) Dashboard container objects which auto-shrink and auto-grow as needed, and 2) a Tableau Parameter which filters out entire sheets based upon user input.

The net result is the effect of "show me" or chart selection, for a given data set. There are some inherent weaknesses to this approach, but overall it's pretty nifty.