Horserace chart
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.
API information
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:
higher_scores_win boolean
Data type. Useful for data where lower scores beat higher scores – e.g. race times Allowed values:
Header
header_title string
Title.
header_subtitle string
Subtitle.
header_margin number
Margin.
header_color color
Color.
header_align string
Alignment. Allowed values:
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:
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.
Footer
footer_source_name string
Source name.
footer_source_url string
Source url.
footer_multiple_sources boolean
Multiple sources.
footer_source_name_2 string
Source name.
footer_source_url_2 string
Source url.
footer_source_name_3 string
Source name.
footer_source_url_3 string
Source url.
footer_source_label_other boolean
Change source label.
footer_source_label string
Source label.
footer_note string
Note.
footer_size number
Size.
footer_color color
Color.
footer_align string
Alignment. Allowed values:
footer_margin number
Overall.
footer_margin_top number
Top.
footer_margin_right number
Right.
footer_margin_bottom number
Bottom.
footer_margin_left number
Left.
footer_margin_advanced boolean
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:
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:
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.