Data > Visualise
Setting up a Line Visualisation
Line Visualisations are useful when you want to view trends in your data.
- Create a new Visualisation by clicking Add new towards the top-right.
- Choose the Line option, and then click the orange check mark
Note: In this article, the example used will be using a Line Visualisation to compare the activity of two different Curatr courses, over time.
Configuring your Line Axes
- Make sure that the Axes tab is selected.
- In the Y Axis section, you can choose which data you want to compare – following the example, you would set Total unique number of.. and Statements here, and then develop the query further from the Series tab.
- You can use the Name field to give the Visualisation a short description. This will also help you to identify it whenever you add it to a Widget.
Configuring your Line Series
- Make sure that the Series tab is selected.
- Following the example, you would now expand the + Where, + contextActivities, and + grouping sections – then choose the ID of the first course you want to plot.
- Now, use Add query to add a new Series.
- Continuing with the example, now expand the + Where, + contextActivities, and + grouping sections – then choose the ID of the second course you want to plot.
- You can use the Label field at the top of the Query Builder for each Series to give them a more appropriate label, such as the name of the course they’re tracking.
- You may now want to adjust the time frame from the drop-down at the top-right, to make sure the Visualisation shows data in the exact time range that you want it to.
Note: If you need help with using the Query Builder, please see the Query Builder Overview and the other articles in that section.
Your Visualisation should now look something like this:
This visualisation can be viewed as a table instead of as a graph. This will affect all places where visualisation is used.
If you are viewing the Visualisation in Data > Visualisations:
- Select the Options tab.
- Toggle the button for View as a Table.
If you are viewing the Visualisation on a dashboard,
- Click the Menu near the top-left of a widget.
- Click Enable Table View or Disable Table View.