This article describes how to go from a crosstab that contains a date or time variable in the rows...
...to a state where the data is represented by a line chart to see trends over time:
You will need a date/time variable, along with a variable that you would like to see trended over time.
- From the toolbar, select Visualization > Line > Line.
- In the object inspector, go to Inputs > DATA SOURCE and select your date/time variable in the Variables in 'Data' drop-down and the variable being trended over time from the Groups drop-down. Alternatively, if you have already created a crosstab on a Page, you can select it from the Output in 'Pages' drop-down.
- Tick the Automatic box. Any changes in your data or settings will then be shown automatically.
How to Create Small Multiples (Facet, or Panel) Visualizations
How to Create Sparkline Visualizations
Article is closed for comments.