Customize and filter

This 2-3 minute tutorial applies to the New look for Fusion Tables.

Once you've created a map, you've just scratched the surface of Fusion Tables. You can customize many aspects of your maps, you can create and customize charts, you can create custom cards, and you can establish selective filters for your data.

Try it yourself (2-4 minutes):

Create and configure charts

Fusion Tables can build charts too. Use the sample insects data to create a chart visualization:

  1. Open the Astraptes insects table you created in the Create a map tutorial, viewing it in the New look.
  2. Click the [+] and choose Add chart.
  3. Click the second chart icon to see a zoomable line chart.
  4. Choose the columns to use as the Y-Axis and X-Axis values.
    - When there are multiple values for points at a given X value, the chart averages them.

At any time, you can change the chart style by choosing Change chart from the Chart tab menu dropdown. You can create more charts, each with its own styles. These are saved with your table and are available to other viewers and editors.

Customize maps

You can change how a map marker's information is displayed when viewers click on it and how the markers look on a map.

Change marker information layout

The marker's information is defined by a standard template layout, but you can customize this:

  1. Open the Astraptes insects table to the map you created in the Create a map tutorial, or add a new Map tab on a demo Astraptes caterpillars table.
  2. Select Tools > Change map, then click the Change info window button.
  3. You have two choices:
    • Add or subtract which Automatic columns to show. By default, it shows the first ten columns.
    • Revise the HTML code in the Custom panel.
  4. To customize the layout template, click the "Custom" tab.

  5. You can write your own HTML to customize the display. Here we provide some code you can copy and paste into the text box. You indicate a column by using its name inside curly brackets, so you'd use {URL adult} or {herbivore species} to insert these columns.
    <div class="googft-info-window"
        style="font-family: sans-serif; width: 330px; height: 20em; overflow-y: auto;">
      <img src="{URL cp lateral}" style="width: 150px; vertical-align: top; margin-right: .5em" />
      <img src="{URL adult}" style="width: 150px; vertical-align: top" />
      <h2 style="color: brown">{herbivore species}</h2> 
      <p>Caterpillar found feeding on host plant <em>{host plant species}</em>,
          {host plant family} in the {primary eco},{year}.</p>
      <p>See specimen record {voucher} at <a href="http://janzen.sas.upenn.edu/">
          Caterpillars, pupae, butterflies and moths of the A.C.G.</a></p>
    </div>
  6. Click Save.
  7. Click a map marker to see the new information display. This is much easier to read than the default text and images.

     

 

Change marker styles

But the map markers are still those small red dots (default for new tables). You can change their styles. For example, the insects' wingspans range from 43-69mm. You can vary marker sizes and colors by wingspan length:

  1. Click on the "Map of latitude" tab and Select Tools >  Change map, then click the Change feature styles button.
  2. Click on Marker icon in the left panel and Buckets in the right panel.
  3. Choose the windspan (mm) from the column dropdown menu.
  4. Enter 0, 45, 55, 65, and 100 in the text fields to create custom bucket sizes.
  5. Change the first and last marker to be large ones by clicking on their dropdown menus.

    buckets
  6. Click Save. Now your map clearly shows the outliers.

outliers

Now you've customized the placemarkers and how their information is displayed. Good job!

You can create more Map tabs, each with unique information layout template and marker styles. These are saved with your table and are available to other viewers and editors.

Use cards

The New look's Cards feature gives you control over display of your rows. You can see many rows as if in a stack of index cards.

Here are examples with three different card layouts:

card text card w/images long card

To do this:

  1. Open an Astraptes caterpillars table.
  2. Click the "Card 1" tab and choose Change card layout from the tab's dropdown menu.
  3. To select fewer columns, stay on the Automatic panel and deselect some columns.
  4. To customize the text, click Custom and modify the HTML, as you did for the information layout template.

You can create more Card tabs, each with its own name and display format. These are saved with your table and are available to other viewers and editors.

Filter and summarize data

You may want to focus on a subset to see the story better. There are two ways to do this within a table: filters and summaries.

Filtering data

Each time you set a filter criteria, Fusion Tables tells you how many rows match. As you add more criteria, the numbers show many match all the criteria. Extra filters are displayed in the left bar and the query text is shown above the rows.

To filter your data for all CELT or LOHAMP male insects:

  1. Open an Astraptes caterpillars table.
  2. Click Filter from any tab.
  3. Choose "herbivore species" from the dropdown menu. A filter box is displayed on the left side.
  4. Click on CELT and LOHAMP. This matches 24 rows.

    filters

     
  5. Click on Filter.
  6. Choose "sex" from the menu.
  7. Click "male." Now only 8 match.

You can add or remove any filter and the number of matches changes.

What data does my filter apply to?

  • You can filter from any tab and the filter is applied to that tab only. The data on existing tabs remains unchanged. If, however, you now create a new tab while on a filtered tab, the filters are also applied to the new tab and you'll only see the filtered data points.
  • If you are using filters, only those that are simple "column=value" conditions let you create a view. That is, a "year >= 2000 AND year <= 2010" filter dims the Create view command. You can only use simple filters like "sex=male" and "host plan family = Malvaceae."

How do I download filtered data?

If you choose File > Download while on a filtered tab, you can choose to download only the "filtered rows" or you can click "All rows" to download all your data.

Summarizing data

You can get a summary too. Fusion Tables' New look lets you get both an aggregated table plus a chart.

To do this:

  1. Click [+] > Add summary.
  2. Choose "elevation" as the column you want to Summarize by.
  3. Choose "wingspan (mm)" as the column you want to Show and click Average.
  4. Click Save. By default you get a table as well as a chart of the top 10 values for columns other than Count.

    summary

Next step

You may want to let everyone see your map or chart, embed it in a webpage, or only provide some of your data to others. The next tutorial, Share and Publish, covers these topics.