Introduction #
SmartChart deeply integrates AI into all major development interfaces: dataset development, chart configuration, and template development. You can describe requirements in natural language, and AI directly generates SQL, ECharts configurations, or HTML code, greatly improving development efficiency.
Use Cases #
- Generate SQL queries with natural language
- Generate ECharts chart configurations from descriptions
- Intelligent Q&A style data analysis
Prerequisites #
AI development features depend on a model data source named smtgpt. Before use, ensure this connection is created in data source management (see “First AI Scene” for configuration).
Usage #
- Development uses the smtgpt model data source, ensure it’s configured first
- Find the AI icon in template/dataset/container/chart development, input your question, select and click to generate
- For data Q&A in datasets, select SQL or table name, then click menu “Tools” -> “GPT Scene”
AI Development Tips #
| Scenario | Action | Example Prompt |
|---|---|---|
| Generate SQL | Enter description in dataset editor | “Query sales by province, descending order” |
| Generate chart | Enter description in chart editor | “Make this data a bar chart with value labels” |
| Modify config | Select existing config, describe changes | “Change colors to blue, font size to 14” |
| Data Q&A | Select table name, click GPT Scene | “What’s the daily average sales in the last 7 days?” |
More specific prompts yield better results. Include table/field names, metric calculation methods, and display format.