Locoia
Search…
Multiple Line Chart

Introduction

The Multiple Line Chart displays data of one series, separated into different lines:
Multiple Line Chart
Multiple Line Charts can also be achieved with the Line Chart, however, the Line Chart expects the data for each line to be in a separate column, which might not be the case with your data. E.g., if your data source consists of revenue data, with date, company, revenue amount, etc., there would usually not be a column for each company, but rather a column Company which then has the different company names in it. So, the data would need to be transformed in order for each company to have its own column; hence the Multiple Line Chart can handle this case better, as it will be explained in the next section.

Expected Data and Graph Designer

The Multiple Line Chart expects data in a three-column format, with the x-axis value as the first column, the line name as the second column, and the value of the line as the third column (just like the Stacked Bar Chart):
Month & Year
Company
Revenue
September 2020
Dinglam
11323
September 2020
Templatdax
12921
September 2020
Movela
7578
September 2020
Ganjanix
8735
September 2020
Doubleity
10664
October 2020
Dinglam
14716
So there needs to be a row for every x-axis value and corresponding line.
Therefore, new lines can simply be added by adding a new row with the line's data for the corresponding x-axis value.
This required format can be achieved in SQL with a GROUP BY statement which groups by the x-axis value and the line name and forms the sum of the line value.
The selection of the x-axis in the Graph Designer does not have an effect.
Last modified 4mo ago