Tuesday, May 4, 2010

Plotting against a zero value

Interesting request for a visual... The selected category should exist at 0,0 and then other categories should be compared against this category. I'll write this up in further detail as time permits.

The example below shows state "Per Capita Income" and "Percentage of College Degrees" against all other states. The selected state is positioned at 0,0.

The data comes from http://www.census.gov/compendia/statab/rankings.html

More information describing how to do this is shown below the visual.

This was basically a self join on the table, where state <> state (not equal to). Then, I was able to create very simple calcs to create the X and Y coordinates for "other states" as compared to my selected state.

Here is a picture of the join:

and here is the actual data that I used. I had to combine the two statistics (income per capita, and percent BA degrees) into one table, as the census folks don't like handing out arbitrary cohort analytics to the general public!! :)

Monday, May 3, 2010

Marking an Action as a Global Quickfilter

This is a relatively simple post to point out that you can mark Tableau actions as global quickfilters. The advantage to doing so is so that you can continue to use the action on the target sheet or dashboard. This most commonly becomes critical when you are jumping across data sources, or jumping from one Tableau dashboard to a different Tableau dashboard.