Horserace chart

A “horserace” or “bump” chart to show changing rank over time

Updated 6 years ago by Template retirement home

How to use this template

This template is ideal for showing the changing fortunes of candidates in elections, football teams, etc. It provides two modes, and allows you to animate between them: a line chart, which plots the raw values in the data, and a “bump” chart, which computes and plots the ranks.

Data requirements

Each row after the header row should be a participant in the race – such as a politician or team. There should be a column for the participant’s name, and multiple columns for the “stages” in the race (week, day, hours, etc). Each stage is plotted at an equal width on the x axis.

Tips

  • You can add a photo or image for each competitor by putting the URL of an image file in the relevant column in the spreadsheet. Use small images to avoid loading delays.
  • In the settings panel, you can decide whether to show scores or ranks, or to reveal buttons to let the viewer see both.
  • In the Flourish story editor, try clicking on the axis labels to show different stages of the race in different slides.

Credits

Created by the Flourish team, inspired by Google News Lab. Want to see additional features? Let us know at support@flourish.studio. Developers can also submit a pull request.

This section documents API usage specific to this template, so for an introduction we suggest you refer to the generic API documentation instead.

template: _195

version: _15

Template data

There are three different formats in which you can supply data to this template. The most convenient for you to use likely depends on the source of your data, as described below.

1. Array of arrays, and a bindings object

You can supply arrays of arrays to opts.data, which might look like:

{
    data: {
        horserace: [
            [ "HorseraceColumn1Value1", "HorseraceColumn2Value1",
            [ "HorseraceColumn1Value2", "HorseraceColumn2Value2",
            [ "HorseraceColumn1Value3", "HorseraceColumn2Value3",
            ...
        ]
    }
}

where each array of arrays represents the rows in a data sheet.

To tell the API how the values from each column should be associated with the keys that the template is expecting, you must also supply an object attached to opts.bindings. (The meanings of the keys in the bindings object are documented below.) The minimal bindings you can supply for this template are as shown in this example:

{
    template: "_195",
    version: "_15",
    bindings: {
        horserace: {
            name: 0, // index of a column in your data
        }
    },
    data: {
        horserace: [
            [ "HorseraceColumn1Value1", "HorseraceColumn2Value1",
            [ "HorseraceColumn1Value2", "HorseraceColumn2Value2",
            [ "HorseraceColumn1Value3", "HorseraceColumn2Value3",
            ...
        ]
    }
}

All possible bindings that you can supply are shown in this example:

{
    template: "_195",
    version: "_15",
    bindings: {
        horserace: {
            name: 0, // index of a column in your data
            pic: 1, // index of a column in your data
            stages: [2, 3, ...], // index(es) of column(s) in your data
            filter: 4, // index of a column in your data
        }
    },
    data: {
        horserace: [
            [ "HorseraceColumn1Value1", "HorseraceColumn2Value1",
            [ "HorseraceColumn1Value2", "HorseraceColumn2Value2",
            [ "HorseraceColumn1Value3", "HorseraceColumn2Value3",
            ...
        ]
    }
}

2. Array of objects with arbitrary keys, and a bindings object

This format is most likely useful when you have data from an external source, such as CSV data loaded from d3-dsv. You should supply this attached to the opts.data, which might look like:

{
        horserace: [
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            ...
        ]
    }

... but with the keys being the column headers from your source data instead. You must also supply an object attached to opts.bindings. The minimal bindings you can supply for this template are as shown in this example:

{
    template: "_195",
    version: "_15",
    bindings: {
        horserace: {
            name: "HorseraceHeader1",
        }
    },
    data: {
        horserace: [
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            ...
        ]
    }
}

All possible bindings that you can supply are shown in this example:

{
    template: "_195",
    version: "_15",
    bindings: {
        horserace: {
            name: "HorseraceHeader1",
            pic: "HorseraceHeader2",
            stages: ["HorseraceHeader3", "HorseraceHeader4", ...],
            filter: "HorseraceHeader5",
        }
    },
    data: {
        horserace: [
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            { "HorseraceHeader1": ..., "HorseraceHeader2": ..., ... },
            ...
        ]
    }
}

(As before, the keys containing "Header" would be replaced by column names from your data source.)

3. Array of objects with template-defined keys

There is an alternative format you can use, which is likely to be easier to use if your data is not from a spreadsheet source. With this alternative format you supply your data to the template as an array of objects, attached to opts.data, where the keys must be those used by the template, as documented below. In this case there is no need to supply a bindings object, since the key names are already those expected by the template. The required properties in the data object are as follows (scroll down for a description of what each property is):

{
    template: "_195",
    version: "_15",
    data: {
    horserace: [
        {
            name: ...,
            stages: [...]
        },
        ...
    ]
},
    ...
}

And the full list of all possible properties is as follows:

{
    template: "_195",
    version: "_15",
    data: {
    horserace: [
        {
            name: ...,
            pic: ...,
            stages: [...],
            filter: ...
        },
        ...
    ]
},
    ...
}

Meanings of the template data keys:

  • horserace.name: The name of each entrant
  • horserace.pic: The URL of the image to use
  • horserace.stages: Raw scores, which will be automatically converted to ranks. Column names will be used to populate the x-axis of the chart.
  • horserace.filter: Hide/show entrants based on the values in this column.

Template settings

Options for opts.state.

Scoring type

value_type string

Chart mode to show on load.

Allowed values:

  • ranks (Ranks)
  • scores (Scores)

higher_scores_win boolean

Data type. Useful for data where lower scores beat higher scores – e.g. race times

Allowed values:

  • true (Higher scores win)
  • false (Higher scores lose)

header_title string

Title.

header_subtitle string

Subtitle.

header_margin number

Margin.

header_color color

Color.

header_align string

Alignment.

Allowed values:

  • left (fa-align-left)
  • center (fa-align-center)
  • right (fa-align-right)

Interface

show_buttons boolean

Show ranks/scores buttons.

show_replay boolean

Show replay button.

filter_control_type string

Filter control type. Only used when a filter column is specified. "Auto" creates a button group if there is enough space, or a dropdown if there is not.

Allowed values:

  • auto-buttons (Auto)
  • dropdown (Dropdown)
  • grouped-buttons (Grouped buttons)

filter_width number

Control width. Width of control if sufficient space is available.

Min: 50

filter_include_all boolean

Include “All” option.

label_ranks string

“Ranks” label.

label_scores string

“Scores” label.

label_replay string

“Replay” label.

filter_all_label string

“All” label.

Source name.

Source url.

Multiple sources.

Source name.

Source url.

Source name.

Source url.

Change source label.

Source label.

Note.

Size.

Color.

Alignment.

Allowed values:

  • left (fa-align-left)
  • center (fa-align-center)
  • right (fa-align-right)

Overall.

Top.

Right.

Bottom.

Left.

Advanced.

Line styles

line_width number

Line width. Width in pixels

line_opacity number

Line opacity. Set to a value between 0 and 1

Max: 1

curve string

Curve.

Allowed values:

  • curveLinear (Straight)
  • curveMonotoneX (Normal curve)
  • curveNatural (Overflowing curve)
  • curveStep (Step middle)
  • curveStepAfter (Step after)
  • curveStepBefore (Step before)

shade boolean

Show shading behind line.

shade_width number

Shading width. Width in pixels

shade_opacity number

Shading opacity. Set to a value between 0 and 1

Max: 1

missing boolean

Show lines between missing data points.

missing_opacity number

Line opacity.

Max: 1

missing_width number

Line width.

missing_dash_width number

Line dash width.

missing_dash_space number

Line dash space.

Circles and labels

start_circle_r number

Start radius.

end_circle_r number

End radius.

end_circle_stroke number

End stroke.

end_circle_stroke_bg boolean

Stroke color same as background.

rank_font_size number

Rank font size.

label_font_size number

Label font size.

label_decimals number

Number of decimal places on scores.

rank_label_suffix string

Suffix.

horse_images boolean

Use image.

rank_outside_picture boolean

Put score next to circle.

hide_labels boolean

Only show label on mouseover.

Colours

bg_color color

Background colour.

palette string

Colour scheme. Select a color scheme, or fill in a comma separated list of color values (eg. '#855C75,#D9AF6B,#AF6458')

Predefined values:

  • flourish_default_1 (Flourish categories A)
  • flourish_default_2 (Flourish categories B)
  • carto_pastel (Pastel light)
  • carto_antique (Pastel dark)
  • carto_rainbow (Rainbow)
  • schemeCategory10 (Category 10)
  • schemeCategory20 (Category 20)
  • schemeCategory20b (Category 20b)
  • schemeCategory20c (Category 20c)
  • schemeAccent (Accent)
  • schemeDark2 (Dark 2)
  • schemePaired (Paired)
  • schemePastel1 (Pastel 1)
  • schemePastel2 (Pastel 2)

Animation

stage_duration number

Animation duration. The “race” animation length, in milliseconds per stage

update_duration number

Mode duration. The animation duration when change between ranks and scores modes

Margins

margin_top number

Top.

margin_right number

Right.

margin_bottom number

Bottom.

margin_left number

Left.

Y axis

y_axis_min number

Min score.

y_axis_max number

Max score.

y_axis_min_rank number

Min rank.

y_axis_max_rank number

Max rank.

y_axis_rounding boolean

Round y axis.

y_axis_tick_prefix string

Number prefix.

y_axis_tick_suffix string

Number suffix.