Replies: 1 comment
-
Hello and welcome to SQLPage ! Let's say you have a table named
and you want to generate the same graph as in the documentation. You start by connecting SQLPage to your database by editing {
"database_url": "mssql://username:password@localhost/YourDatabaseName"
} Then you create a file named select
'chart' as component,
'Quarterly Revenue' as title,
'area' as type,
'indigo' as color,
5 as marker,
TRUE as time;
select
date as x,
value as y
from
charts; The second select will fetch the values from your table and return them in the format expected by the SQLPage chart component. You can then launch SQLPage and open http://localhost:8080/my_chart.sql and you will see your graph appear. |
Beta Was this translation helpful? Give feedback.
-
explain how to build a graph from a remote database please
select [date], [value] From bd.charts
How can I build a graph using my example, please explain
I need a for loop ?
https://sql.ophir.dev/documentation.sql?component=chart#component Example 1
Beta Was this translation helpful? Give feedback.
All reactions