自定义行头和自定义列头同时配置时, data应该如何配置才能正确显示?

[gx371368714]

配置如下

fields: { "rows": [ { "field": "u_b00c569e7b75a15f_1-2016", "title": "2016", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品1", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术1", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-5-groupY", "title": "小计2-3", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-6-groupY", "title": "小计2", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ] }, { "field": "u_b00c569e7b75a15f_1-2017", "title": "2017", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-5-groupY", "title": "小计2-3", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-6-groupY", "title": "小计2", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ] }, { "field": "u_b00c569e7b75a15f_1-2018", "title": "2018", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-5-groupY", "title": "小计2-3", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-6-groupY", "title": "小计2", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ] }, { "field": "u_b00c569e7b75a15f_1-2019", "title": "2019", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-7-groupY", "title": "小计3", "children": [] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-5-groupY", "title": "小计2-3", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-6-groupY", "title": "小计2", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-1-groupY", "title": "小计1-2-3", "children": [] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-2-groupY", "title": "小计1-2", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-3-groupY", "title": "小计1", "children": [ { "field": "u_9da60b994766ee0d_2-一级", "title": "一级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-二级", "title": "二级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-当日", "title": "当日", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] }, { "field": "u_9da60b994766ee0d_2-标准级", "title": "标准级", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ] }, { "field": "01JKFPT40RW8PCG64AFZP74YNS-4-groupY", "title": "小计1-3", "children": [ { "field": "u_8aa750665b3b44d2_3-办公用品", "title": "办公用品", "children": [] }, { "field": "u_8aa750665b3b44d2_3-家具", "title": "家具", "children": [] }, { "field": "u_8aa750665b3b44d2_3-技术", "title": "技术", "children": [] } ] } ], "columns": [ { "field": "u_110c12e0908d8225_0-东北", "title": "东北", "children": [ { "field": "u_fbf89a66d9552b4d_6-吉林", "title": "吉林", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-辽宁", "title": "辽宁", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-黑龙江", "title": "黑龙江", "children": [] } ] }, { "field": "u_110c12e0908d8225_0-中南", "title": "中南", "children": [ { "field": "u_fbf89a66d9552b4d_6-广东", "title": "广东", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-广西", "title": "广西", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-河南", "title": "河南", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-海南", "title": "海南", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-湖北", "title": "湖北", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-湖南", "title": "湖南", "children": [] } ] }, { "field": "u_110c12e0908d8225_0-华东", "title": "华东", "children": [ { "field": "u_fbf89a66d9552b4d_6-上海", "title": "上海", "children": [] }, { "field": "u_fbf89a66d9552b4d_6-安徽", "title": "安徽", "children": [] } ] }, { "field": "01JN2NJFXVSR7VHFJCQX55VHDD-1-groupX", "title": "小计", "children": [] } ], "values": [ "u_38c3a422aba3d6ff_4", 'u_8aa750665b3b44d2_3-技术1', "u_fbf89a66d9552b4d_6-吉林", "u_fbf89a66d9552b4d_6-辽宁", "u_8aa750665b3b44d2_3-办公用品1", ] },

此时展示 结果是

此时 data的结构应该是啥样的. 我在values里写了这个"u_fbf89a66d9552b4d_6-吉林", 给 "u_fbf89a66d9552b4d_6-吉林"赋值 12, 展示结果是 吉林这一列都是12, 没办法在行上找到对应节点

[petercat-assistant[bot]]

在配置自定义行头和列头时，确保数据能够正确显示的关键在于数据结构的设计。根据你提供的配置，以下是一些建议，帮助你正确配置数据：

1. 数据结构设计：

   • 确保每个数据项都能唯一地映射到行和列的组合。通常情况下，数据应该是一个数组，其中每个对象代表一个数据点，包含行字段和列字段的组合。
   • 例如，数据结构可以是这样的：

     [
       {
         "rowField": "u_b00c569e7b75a15f_1-2016",
         "columnField": "u_fbf89a66d9552b4d_6-吉林",
         "value": 12
       },
       {
         "rowField": "u_b00c569e7b75a15f_1-2017",
         "columnField": "u_fbf89a66d9552b4d_6-辽宁",
         "value": 15
       }
       // 更多数据项
     ]

2. 确保字段匹配：

   • 在 fields 中定义的 row 和 column 字段应该与数据中的 rowField 和 columnField 一一对应。
   • 确保 values 中的字段与数据中的 value 字段相匹配。

3. 数据映射：

   • 在渲染时，确保使用正确的字段来映射数据到表格的行和列。通常需要在渲染逻辑中根据 rowField 和 columnField 找到对应的单元格，然后填入 value。

4. 调试和验证：

   • 在调试时，可以先手动检查数据结构是否正确映射到每个单元格。
   • 使用日志或调试工具查看每个数据点是否正确匹配到行和列。

通过以上步骤，你应该能够正确配置数据，使其在自定义行头和列头的表格中正确显示。如果仍有问题，可能需要进一步检查渲染逻辑或数据结构的其他部分。

如果你有更多具体问题或需要进一步的帮助，请随时告诉我！

🪧 Tips

For further assistance, please describe your question in the comments and @petercat-assistant to start a conversation with me.

[gx371368714]

这个数据结构 s2 好像不支持, 这么设置并不生效