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

Google image search

Google image search allows you to search an image’s URL (or upload an image) to find where that image appears online and to find similar images.

Beware that similar images may be visually similar but not necessarily related, as in this example:

image search example

Photographers can use image search to see if their photo is being used on other websites. Social media editors can use it to make sure a user-submitted photo of a news event isn’t actually an old image, and anyone can use it to find out where an image originated. (Click on the links in that previous paragraph for examples and for information about Tineye and other ways to do reverse image searches.)

How to do it:

Go to images.google.com and click the camera icon in the search box. Paste the URL of an image on the web, or upload an image from your computer.

A browser extension for Google Chrome or Firefox lets you do an image search from any image on the web by right-clicking on it.

iWitness: Explore social media content by time and place

Try iWitness here. Note: It works with Google Chrome and Safari, but not Firefox or Internet Explorer.

About iWitness, from the iWitness FAQ:

Q: What is iWitness?
A: iWitness is a free, web-based software tool that makes it easy for people to explore social media content by time and place.

Q: How does it work?
A: iWitness scans social media services for content that a user has attached a location to. Any content without a location attached to it does not show up in iWitness.

Q: What social media services does iWitness support?
A: The initial release of iWitness scans Twitter and Flickr. It can also show photos and videos posted to Twitter that are hosted on the following services:

Photos: Twitter, Instagram, Twitpic, Twitgoo, Lockerz
Videos: YouTube, Twitvid, Vimeo

Q: What about Facebook? I love Facebook!
A: We love Facebook too. But Facebook doesn’t let us access the location associated with a piece of content. We hope they will in the future. Fortunately, iWitness is an open-source tool, meaning anyone can modify it or extend it to support new services.

Q: What browsers does iWitness work on? Can I use it on my phone or tablet?
A: iWitness works with WebKit-based browsers such as Google Chrome or Safari. You can use it on an iPad, but it’s not designed to work on the small screens of mobile phones.

Q: Where does the source code live?
A: You can access the source code repository at https://github.com/adaptivepath/iWitness.

Q: Who created iWitness?
A: These folks:

Adaptive Path design team
Product Concept, Project Lead, and UX Design:
Jesse James Garrett
Visual Design: Vanessa Stepanenko
Project Manager: Eun-Joung Lee

New Context development team
John Andrews
Alex Burkhart
Mike Enriquez
Adam McCrea
Jerry Nümmi
Project Manager: Mike Doel