public-api L1会话消息列表

{
    "code": 200,
    "data": [
        {
            "theme_id": "3d9bc079-74c4-4aae-bee1-550beec6f0fa",
            "session_id": "b338272b-e020-4d1e-bc33-3d25c8ac16f8",
            "message_id": "6b6f5ba0-390a-44a7-93d4-6dcab72cb70f",
            "question": "销售增长率Top10的城市",
            "rewritten_question": "销售增长率Top10的城市",
            "answer": {
                "action": "query",
                "explain": "该查询旨在找出销售增长率最高的前十个城市，通过计算每个城市每月的销售额，并与上月销售额进行比较，最终得出平均增长率。",
                "thoughts": "To find the top 10 cities with the highest sales growth rate, I need to calculate the growth rate for each city and then order them by this rate.",
                "query": "WITH `CityMonthlySales` AS (SELECT `终端市`, `年`, `月`, SUM(`金额`) AS `月销售额` FROM `明细表` WHERE `终端市` <> '' GROUP BY `终端市`, `年`, `月`), `CityGrowthRates` AS (SELECT `终端市`, `年`, `月`, `月销售额`, LAG(`月销售额`) OVER (PARTITION BY `终端市` ORDER BY `年`, `月`) AS `上月销售额` FROM `CityMonthlySales`), `CityGrowthCalculations` AS (SELECT `终端市`, `年`, `月`, (`月销售额` - `上月销售额`) / `上月销售额` AS `增长率` FROM `CityGrowthRates` WHERE NOT `上月销售额` IS NULL) SELECT `终端市`, AVG(`增长率`) AS `平均增长率` FROM `CityGrowthCalculations` GROUP BY `终端市` ORDER BY `平均增长率` DESC LIMIT 10"
            },
            "sql": "WITH `CityMonthlySales` AS (SELECT `终端市`, `年`, `月`, SUM(`金额`) AS `月销售额` FROM `明细表` WHERE `终端市` <> '' GROUP BY `终端市`, `年`, `月`), `CityGrowthRates` AS (SELECT `终端市`, `年`, `月`, `月销售额`, LAG(`月销售额`) OVER (PARTITION BY `终端市` ORDER BY `年`, `月`) AS `上月销售额` FROM `CityMonthlySales`), `CityGrowthCalculations` AS (SELECT `终端市`, `年`, `月`, (`月销售额` - `上月销售额`) / `上月销售额` AS `增长率` FROM `CityGrowthRates` WHERE NOT `上月销售额` IS NULL) SELECT `终端市`, AVG(`增长率`) AS `平均增长率` FROM `CityGrowthCalculations` GROUP BY `终端市` ORDER BY `平均增长率` DESC LIMIT 10",
            "card": {
                "dimensions": [
                    "终端市"
                ],
                "metrics": [
                    {
                        "name": "平均增长率",
                        "formatType": "PERCENTAGE"
                    }
                ],
                "viz_config": {
                    "xAxis": [
                        {
                            "type": "category"
                        }
                    ],
                    "yAxis": [
                        {
                            "type": "value"
                        }
                    ],
                    "series": [
                        {
                            "type": "bar",
                            "encode": {
                                "x": "终端市",
                                "y": "平均增长率",
                                "value": null,
                                "itemName": null
                            },
                            "yAxisIndex": null,
                            "label": true
                        }
                    ]
                }
            },
            "recommended_cards": [
                {
                    "card_id": "p3316b9dbf8ed4b479500962",
                    "card_name": "用户访问次数",
                    "page_id": "sfaa1c3306db24e2e8ba1d14",
                    "page_name": "BI平台用户行为分析",
                    "recommend_id": "ab5dc6e4-83df-4100-a026-40750abe126d",
                    "relevance_score": 6.466653,
                    "is_relevant_feedback": true
                }
            ],
            "table": [
                {
                    "table_id": "n46c4d92b623041ada6c209c",
                    "table_name": "明细表"
                }
            ],
            "user_info": {
                "user_id": "bWF0YW9AZ3VhbmRhdGEuY29t",
                "username": null
            },
            "feedback": {
                "is_collected": false,
                "vote": {
                    "vote_type": null,
                    "comment": null
                }
            },
            "answer_status": "success",
            "created_at": "2024-10-08 17:35:11",
            "query_status": "success",
            "query_result": {
                "columns": [
                    {
                        "name": "终端市",
                        "fdType": "STRING",
                        "seqNo": 0
                    },
                    {
                        "name": "平均增长率",
                        "fdType": "DOUBLE",
                        "seqNo": 1
                    }
                ],
                "preview": [
                    [
                        "桂林市",
                        "32.409091"
                    ],
                    [
                        "石家庄市",
                        "21.696739"
                    ],
                    [
                        "呼和浩特市",
                        "8.650959"
                    ],
                    [
                        "郑州市",
                        "5.961451"
                    ],
                    [
                        "神农架林区",
                        "5.760847"
                    ],
                    [
                        "恩施市",
                        "5.396952"
                    ],
                    [
                        "南昌市",
                        "1.935376"
                    ],
                    [
                        "张家界市",
                        "1.039843"
                    ],
                    [
                        "抚州市",
                        "0.641807"
                    ],
                    [
                        "鄂州市",
                        "0.622905"
                    ]
                ]
            }
        }
    ]
}