交叉表按日交叉

交叉报表–交叉表按日交叉—日报表

概述

交叉表按日交叉：按日交叉表，即通常所说的日报表。

应用场景

如下图所示，简单展示数据

示例说明

数据准备

在数据面板中添加数据集，可选择Json数据集和Http接口数据集，Json数据如下图所示：

[{"公司":"百达电子","日期":3,"金额":535.2},{"公司":"玉钰公司","日期":1,"金额":322},{"公司":"玉钰公司","日期":2,"金额":1520},{"公司":"玉钰公司","日期":2,"金额":696.5},{"公司":"玉钰公司","日期":29,"金额":51},{"公司":"玉钰公司","日期":2,"金额":1060},{"公司":"大鱼系统","日期":11,"金额":252.6},{"公司":"大鱼系统","日期":11,"金额":390},{"公司":"大鱼系统","日期":10,"金额":156.5},{"公司":"高上公司","日期":3,"金额":2500},{"公司":"高上公司","日期":3,"金额":1400},{"公司":"光明杂志","日期":24,"金额":360},{"公司":"光明杂志","日期":24,"金额":116},{"公司":"光明杂志","日期":15,"金额":493},{"公司":"国顶有限公司","日期":4,"金额":236.5},{"公司":"国顶有限公司","日期":4,"金额":1060},{"公司":"国顶有限公司","日期":4,"金额":210},{"公司":"国顶有限公司","日期":7,"金额":590.4},{"公司":"国顶有限公司","日期":4,"金额":45},{"公司":"国皓","日期":5,"金额":115.5},{"公司":"国皓","日期":5,"金额":432},{"公司":"国皓","日期":12,"金额":635},{"公司":"国皓","日期":12,"金额":150},{"公司":"国皓","日期":12,"金额":1125},{"公司":"国皓","日期":30,"金额":625},{"公司":"华科","日期":11,"金额":595.5},{"公司":"华科","日期":11,"金额":112.5},{"公司":"华科","日期":16,"金额":2250},{"公司":"华科","日期":16,"金额":315},{"公司":"华科","日期":6,"金额":360},{"公司":"华科","日期":28,"金额":650},{"公司":"建国科技","日期":9,"金额":493},{"公司":"建国科技","日期":9,"金额":50},{"公司":"建国科技","日期":2,"金额":25},{"公司":"兰格公司","日期":13,"金额":260},{"公司":"兰格公司","日期":2,"金额":360},{"公司":"兰格公司","日期":2,"金额":156.35},{"公司":"瑞栈工艺","日期":9,"金额":396.5},{"公司":"瑞栈工艺","日期":9,"金额":165},{"公司":"森通","日期":26,"金额":252},{"公司":"森通","日期":26,"金额":65},{"公司":"伸格公司","日期":19,"金额":35},{"公司":"伸格公司","日期":14,"金额":36.5},{"公司":"伸格公司","日期":19,"金额":493},{"公司":"伸格公司","日期":19,"金额":200.5},{"公司":"伸格公司","日期":23,"金额":234},{"公司":"伸格公司","日期":23,"金额":155},{"公司":"伸格公司","日期":8,"金额":150},{"公司":"升格企业","日期":30,"金额":1236.9},{"公司":"升格企业","日期":30,"金额":516},{"公司":"升格企业","日期":17,"金额":360},{"公司":"师玉公司","日期":12,"金额":650},{"公司":"师玉公司","日期":12,"金额":159},{"公司":"师玉公司","日期":27,"金额":2200},{"公司":"坦森行公司","日期":19,"金额":520},{"公司":"坦森行公司","日期":19,"金额":602},{"公司":"坦森行公司","日期":21,"金额":560},{"公司":"通恒机械","日期":15,"金额":209.4},{"公司":"通恒机械","日期":15,"金额":116.25},{"公司":"通恒机械","日期":22,"金额":920},{"公司":"通恒机械","日期":15,"金额":320},{"公司":"五洲信托","日期":6,"金额":194.5},{"公司":"五洲信托","日期":6,"金额":2650},{"公司":"协昌妮绒有限公司","日期":23,"金额":150},{"公司":"协昌妮绒有限公司","日期":20,"金额":250},{"公司":"协昌妮绒有限公司","日期":23,"金额":405.45},{"公司":"兴中保险","日期":25,"金额":155},{"公司":"兴中保险","日期":25,"金额":162.65},{"公司":"幸义房屋","日期":3,"金额":155},{"公司":"幸义房屋","日期":3,"金额":996.5},{"公司":"幸义房屋","日期":5,"金额":156.15},{"公司":"幸义房屋","日期":5,"金额":356.5},{"公司":"幸义房屋","日期":9,"金额":1601},{"公司":"幸义房屋","日期":9,"金额":620},{"公司":"幸义房屋","日期":18,"金额":62}]

报表设计

将数据字段拖入A2、B1、B2单元格，并设置成分组。
将A2设置为向下扩展，B1设置为向右扩展，B2设置为双向扩展。
选中B1(test.日期)，点击上方工具栏-元素-设置显示格式，在添加后缀中加入“日”。
点击上方工具栏此按钮设置交叉表表头，用 | 分隔。

效果预览

交叉表按日交叉–日报表.json

https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1700474856308-da6a00ae-31fc-4d43-828a-37e70cc9b89f.json

参考文档

• 小智报表样例源码下载
  • https://gitee.com/tizdata_admin/vue-xzreport-example.git
• 小智报表demo体验
  • https://xzdemo.tizdata.com/#/imbedShow/reportExample
  • 丰富的报表模板示例
• 小智报表在线试用
  • https://xzreport.com
• 小智报表js sdk下载
  • https://tizdata.com/xzdownload/
• 开发使用文档
  • https://doc.tizdata.com/xiaozhi/650