Making Tableau follow AP style for dollar amounts in thousand and millions in tooltips

Tableau likes to format all its numbers the same way, like this:

$15M
$2.42M
$.45M

OR

$15,000,000
$2,420,000
$450,000

But AP wants us to do it like this:

$15 million
$2.4 million
$450,000

You can use two simple calculated fields to make Tableau show tooltip numbers in AP style:

  1. Convert millions to decimals with this calculated field:
    IF [Amount]>999999
    THEN (ROUND(([Amount]/1000000),2))
    ELSE [Amount]
    END
  2. Add the word million to the amount for the tooltip with another calculated field:
    IIF([Amount]>999999,”million”,””)
  3. Use both calculated fields (and add the $) in the tooltip:
    $<ATTR(Millions thousands calc)> <ATTR(Million for tooltip)>

Timelines, maps, graphs and other data visualizations

Some mapsgraphs and timelines produced by Palm Beach Post staff researchers.


Maps and graphs using Tableau, a free web-based tool for producing interactive charts, graphs and maps.

Palm Beach County home values 2000-2013
Palm Beach County home values

Homicide victims
Palm Beach County homicide victims 2009-2013

Business indicators
Business and economic indicators

Spring training sites
Spring training sites

Executive compensation
executive-compensation-screenshot


Maps using Google Fusion Tables

Florida aviation accidents since 2004
florida-aircraft-accidents-screenshot

Palm Beach home sales
PB-home-sales-map-screenshot

Origins of Palm Beach County place names
Place-names-map-screenshot

County crime data
Crime-map-screenshot


Timelines using TimelineJS, an open-source web-based tool with built-in support for embedding photos, videos and other media.

Everglades timeline
Everglades timeline

Executions in Florida since 1979
florida-executions-screenshot

FAU-timeline-screenshot

Summer-concert-preview-screenshot

SFWMD-timeline-screenshot

Quick and dirty Census maps

Go to the American Factfinder website.

Click on “Topics” and choose people | age group | older population for this example, and then close the topics window.

Click on “Geographies” and choose an area. Choose Census Tracts | Florida | Palm Beach County for this example, and then “All Census Tracts within Palm Beach County” and click on “Add to your selections.” Close the geographies window.

Choose the table RELATIONSHIP BY HOUSEHOLD TYPE (INCLUDING LIVING ALONE) FOR THE POPULATION 65 YEARS AND OVER.

Click on “Create a Map” (one of the “Actions” in blue text, above the table).

To map males older than 65 living alone, click on the number 112 in the estimate column, down there near the bottom (or alternately, the 333 for females living alone).

Click on “Show Map” and wait a few moments for the map to load and you get a color-coded map showing which Census tracts have the most older men living alone in PBC.

Another example showing percentage of households with incomes of $200,000 or more:

The next generation of data searching

Google’s public data search “makes it easy to find and compare public data.” Unemployment and population data (national, state and local) are available now, with promises of more to come. Google “population” or “unemployment” to see what it looks like.

Wolfram|Alpha, launching in May, promises to be even more cool:

What can it do? It can describe places, like Lexington, Mass., by its vital statistics, like location, population, weather, etc. It can compare Lexington with Moscow. If you type “LDL 180,” it will tell you the percentile of the population with higher or lower cholesterol and show you the answer on a chart. If you tell “LDL 180 male 45,” it will adjust the chart for gender and age group. It can chart the life expectancy of a male age 40 in Italy or tell you who was president of Brazil in 1928.