Line Chart
Line charts are one of the most basic and common chart types, which connects a series of individual data points by a sequence of lines, to provide a more complete view. Line charts are useful when you want to visualise how your data is trending over time for example, especially when visualizing time-series data. Line charts can be used to visualize a single data series, or multiple, within the same chart.
How to Build: Single series line chart
For a single series line chart, run your SQL query such that it returns 2 columns of values. The 2 columns of values are required to generate the x and y-axes of the chart. Typically, the x-axis values would be a collection of ordered values, such as date values. Specify the data types within the 'Format Columns' section of the Report Editor. In this example, the 'Date' column uses the date data type, and the 'Customer Signups' column uses the number data type.
Access the Visualization Editor at the bottom of the Report Editor screen, and select the 'Line' chart option button. Under 'General', specify which column will be on the x-axis, such as the 'Date' column, and the column to be on the y-axis, which in this case are the number data values of the 'Customer Signups' column.
How to Build: Multiple series line chart
For a multiple series line chart, run your SQL query such that it returns at least 3 columns of values. All the columns should share one common x-axis, such as date values. In this example, we have 7 columns of values, with 1 date column and 6 country columns for broadcasts. This table of values was actually tabulated using the Holistics 'Quick pivot' feature under the 'Data Settings' section of the Report Editor, for a fast and easy transformation of the data across a column dimension. We specify the data types within the 'Format Columns' section of the Report Editor. In this example, the 'Date' column uses the date data type, the 'Country' column uses the string data type for its values, and the 'Broadcasts' column uses the number data type. Selecting the 'Quick Pivot' transform feature then produced this data table.
Access the Visualization Editor at the bottom of the Report Editor screen, and select the 'Line' chart option button. Under 'General', specify which column will be on the x-axis, such as the 'Date' column. As this table of data was built using the 'Quick Pivot' feature, there is no need to specify the columns for the y-axis. Holistics will then plot the remaining column series of data as multiple line series on the chart, in relation to the x-axis values.
