Trend
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
To add a trend slice:
select Trend from the chart list
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)
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.
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 chart requires a time column. A time column is created from date or time fields in your data. The 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.