智能BI服务

工作流程

展示天（折线，柱状）

{
    "chartType": "line",
    "last_message": "折线图展示2023年11月19日报警记录",
    "rule": true
}

{
    "choices": [
        {
            "delta": {
                "table": {
                    "query": {
                        "alarmType": null,
                        "beginTime": "2023-11-19",
                        "endTime": "2023-11-19"
                    },
                    "data": {
                        "hour": [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23],
                        "count": [11,9,11,13,9,12,9,6,8,13,11,12,9,11,14,14,9,11,10,9,8,11,10,11]
                    }
                }
            }
        }
    ]
}

展示多天（折线，柱状）

{
    "chartType": "line",
    "last_message": "折线图展示2023年11月19日到30日报警记录",
    "rule": true
}

{
    "choices": [
        {
            "delta": {
                "table": {
                    "query": {
                        "alarmType": null,
                        "beginTime": "2023-11-19",
                        "endTime": "2023-11-30"
                    },
                    "data": {
                        "day": ["2023-11-19","2023-11-20","2023-11-21","2023-11-22","2023-11-23","2023-11-24","2023-11-25","2023-11-26","2023-11-27","2023-11-28","2023-11-29","2023-11-30"],
                        "count": [251,262,263,254,256,244,253,269,272,235,259,262]
                    }
                }
            }
        }
    ]
}

展示报警比例（饼图）

{
    "chartType": "line",
    "last_message": "饼图展示2023年11月19日报警记录",
    "rule": true
}

{
    "choices": [
        {
            "delta": {
                "table": {
                    "query": {
                        "beginTime": "2023-11-19",
                        "endTime": "2023-11-19"
                    },
                    "data": {
                        "eventName": ["水体颜色异常检测","交通事故","车辆计数","人员计数","交通拥堵","森林着火点检测","危险车辆","漂浮物检测"],
                        "count": [1,27,75,69,74,2,2,1]
                    }
                }
            }
        }
    ]
}

按小时展示多天（热力图）

{
    "chartType": "line",
    "last_message": "饼图展示2023年11月19日报警记录",
    "rule": true
}

{
    "choices": [
        {
            "delta": {
                "table": {
                    "query": {
                        "beginTime": "2023-11-19",
                        "endTime": "2023-11-30"
                    },
                    "hour": {
                        "eventName": ["2023-11-19 00","2023-11-19 01",...],
                        "count": [1,27,75,...]
                    }
                }
            }
        }
    ]
}