Trend

The trend chart displays a measure plotted over time. Adding a slice with a trend chart (i.e., a trend slice) is a good choice when users want to see how a measure changes over time.

Adding a trend slice

To add a trend slice:

• select Trend from the chart list

Select Trend from the dropdown

• select the time column to use for the x-axis

• select up to 5 measures to display on a single y-axis

• select 1 measure to display on a second y-axis (optional)

• add slice text (optional)

A Trend slice

The trend chart requires a time column. A time column is created from date or time fields in your data. The time format selected for the time column will determine how your dates "roll up" in your trend chart. For example, if you select the format month yyyy, the trend chart will roll up by month. If you select the format yyyy, the trend chart will roll up by year.

Time ingredients will "roll up" in charts to the period selected for the Format. For example, selecting the month yyyy format will roll up to the month. Selecting the yyyy format will roll up to the year.

Adding a trend slice

Using a trend slice

You can hover over individual points to see more detail. Date range selections made in the trend slice will filter downstream slices.

Dates in the data that are missing values will show a break in the trend line, like so:

The trend line has a break because household_size is null for all 1973 dates