Making charts with Infogr.am

  1. Log in (or create a new account) at infogr.am
  2. Click on Create new.
  3. Choose Charts.
  4. Choose type of chart.
  5. Double click on the chart to add your data and customize your chart.
  6. Customize the title and other text, and add other elements if you wish.
  7. Click on the preview icon to see what your chart will look like.
  8. Click on Publish. Enter a title and and choose Publish for everyone.

To embed in Medley or a blog:

  1. Copy the fixed embed code. (Medley and WordPress don’t play well with the responsive code.)
  2. Paste the embed code where you’d like it to appear in a Medley story or blog post.

For now, stories on mysite must be marked free in order for the embed to work.

On WordPress VIP blogs, click on the Add embed button and paste the code into the Insert embed tab.

Advertisements

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)>

TimelineJS tips

TimelineJS makes it easy to create interactive timelines based on a Google spreadsheet.

Follow the instructions here (click on the big green MAKE A TIMELINE NOW button).

A few tips:

  1. Rename the Google spreadsheet template to something like “Everglades timeline” so you don’t end up with multiple spreadsheets named Copy of TimelineJS Template.
  2. Click on More Options in Step 3 so you can change the font and adjust the zoom level (if necessary). The Georgia and Helvetica Neue font looks best on mypalmbeachpost.com.
  3. You can embed links in the headline, text, media credit and caption columns using html like so:

     

        Which will show up like this:
          Charles R Noegel collection, State Archives of Florida,

    Florida Memory

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

Public.Resource.Org

Public.Resource.Org is a non-profit corporation whose motto is “Making Government Information More Accessible”.

From the organization’s articles of incorporation:

The specific purpose of this corporation is to create, architect, design, implement, operate and maintain public works projects on the Internet for Educational, Charitable, and Scientific Purposes to the benefit of the general public and the public interest; to increase and diffuse knowledge about the Internet in its broadest sense; to promote and facilitate the expansion, development, and growth of the public infrastructure of the Internet by any means consistent with the public interest through other activities, including, but not limited to, publications, meetings, conferences, training, educational seminars, and the issuance of grants and other financial support to educational institutions, foundations and other organizations exclusively for Educational, Charitable, and Scientific Purposes.