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.
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.
REQUIRED. The type of chart: "line", "area", "bar", "column", or "pie".
Whether to show the data labels on the chart or not.
Display the y-axis in logarithmic scale..
Whether to cumulate values from different series.
Whether the x-axis represents time. If set to true, the values will be formatted as dates for the user.
The name of the chart.
The maximum value for the y-axis.
The minimal value for the y-axis.
REQUIRED. The value of the point on the horizontal axis
REQUIRED. The value of the point on the vertical axis
An alias for parameter "x"
If multiple series are represented and share the same y-axis, this parameter can be used to distinguish between them.
An alias for parameter "y"
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;
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;
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;