怎样将表记录的数据显示在曲线里

[Jonathan]

如上图是一个检测表，有很多检测记录，每条记录有很多检测项，怎样把所有检测项的数据按时间汇集显示在折线图里，就是折线图里每个检测项都有一条自己的折线

[技术支持fx]

在画面数据源里先创建数据源，转换下图表格式

然后再折线图上绑定数据源参数

[Jonathan]

@生椰拿铁 查询返回的结果字段都是英文字母，还有很多无关的字段，跟表的定义不一样

[
{
"_department": {},
"_departmentInfo": [],
"_deptTableAndField": {},
"_label": "1",
"_parent": [],
"_table": "出水池水质",
"_title": "出水池水质",
"createTime": "2024-08-01T11:26:50.046826+08:00",
"deletePermission": true,
"editPermission": true,
"id": "66ab007a1b8800db81278d00",
"number-141E": 1,
"number-7C1A": 8,
"number-8A8C": 1,
"number-A4D7": 1,
"number-ACC6": 1,
"number-AE6F": 1,
"number-B108": 1,
"number-B656": 1,
"number-D957": 1,
"number-FB5A": 1111,
"select-83E9": "1",
"text-CA6B": 1
},
{
"_department": {},
"_departmentInfo": [],
"_deptTableAndField": {},
"_label": "2",
"_parent": [],
"_table": "出水池水质",
"_title": "出水池水质",
"createTime": "2024-08-01T14:04:19.788929+08:00",
"deletePermission": true,
"editPermission": true,
"id": "66ab25631b8800db81278d5c",
"number-141E": 2,
"number-7C1A": 8,
"number-8A8C": 2,
"number-A4D7": 2,
"number-ACC6": 2,
"number-AE6F": 2,
"number-B108": 2,
"number-B656": 2,
"number-D957": 2,
"number-FB5A": 2222,
"select-83E9": "2",
"text-CA6B": 2
},
{
"_department": {},
"_departmentInfo": [],
"_deptTableAndField": {},
"_label": "1",
"_parent": [],
"_table": "出水池水质",
"_title": "出水池水质",
"createTime": "2024-08-01T14:04:55.961395+08:00",
"deletePermission": true,
"editPermission": true,
"id": "66ab25871b8800db81278d5e",
"number-141E": 3,
"number-7C1A": 3,
"number-8A8C": 3,
"number-A4D7": 3,
"number-ACC6": 3,
"number-AE6F": 3,
"number-B108": 3,
"number-B656": 3,
"number-D957": 3,
"number-FB5A": 3,
"select-83E9": "2",
"text-CA6B": 3
}
]