SQLPage documentation
The two most important concepts in SQLPage are components and parameters. This page documents all the components that you can use in SQLPage and their parameters. Use this as a reference when building your SQL application.
components
The "chart" component
A component that plots data. Line, area, bar, and pie charts are all supported. Each item in the component is a data point in the graph.
Top-level parameters
type
REQUIRED. The type of chart: "line", "area", "bar", "column", or "pie".
labels
Whether to show the data labels on the chart or not.
logarithmic
Display the y-axis in logarithmic scale..
stacked
Whether to cumulate values from different series.
time
Whether the x-axis represents time. If set to true, the values will be formatted as dates for the user.
title
The name of the chart.
ymax
The maximum value for the y-axis.
ymin
The minimal value for the y-axis.
Row-level parameters
x
REQUIRED. The value of the point on the horizontal axis
y
REQUIRED. The value of the point on the vertical axis
label
An alias for parameter "x"
series
If multiple series are represented and share the same y-axis, this parameter can be used to distinguish between them.
value
An alias for parameter "y"
Example 1
A pie chart.
SELECT
'chart' as component,
'Answers' as title,
'pie' as type,
1 as labels;
SELECT
'Yes' as label,
65 as value;
SELECT
'No' as label,
35 as value;
Result
Answers
Example 2
An area chart
SELECT
'chart' as component,
'Syracuse' as title,
'area' as type;
SELECT
0 as x,
15 as y;
SELECT
1 as x,
46 as y;
SELECT
2 as x,
23 as y;
SELECT
3 as x,
70 as y;
SELECT
4 as x,
35 as y;
SELECT
5 as x,
106 as y;
Result
Syracuse
Example 3
A bar chart with multiple series.
SELECT
'chart' as component,
'Expenses' as title,
'bar' as type,
1 as stacked;
SELECT
'Marketing' as series,
2021 as x,
35 as value;
SELECT
'Marketing' as series,
2022 as x,
15 as value;
SELECT
'Human resources' as series,
2021 as x,
30 as value;
SELECT
'Human resources' as series,
2022 as x,
55 as value;