missing time field in sql in data aggregation

[da730]

model：skylark-2-pro
sql: "SELECT city, SUM(sales) AS total_sales FROM VMind_data_source GROUP BY city",
user prompt: 按时间看杭州销量
fieldInfo：[
{
"fieldName": "key",
"type": "int",
"role": "measure",
"domain": [
0,
499
]
},
{
"fieldName": "id",
"type": "int",
"role": "measure",
"domain": [
1,
502
]
},
{
"fieldName": "order_id",
"type": "date",
"role": "dimension",
"domain": [
"US-2019-1357144",
"CN-2019-1973789",
"US-2019-3017568",
"CN-2018-2975416",
"CN-2017-4497736",
"CN-2016-4195213",
"CN-2019-5801711",
"CN-2017-2752724",
"US-2018-2511714",
"CN-2019-5631342",
"US-2018-4150614",
"CN-2019-4364300",
"CN-2019-3230180",
"US-2018-1966627",
"CN-2018-1190387",
"CN-2018-3216455",
"CN-2018-4690757",
"CN-2018-4674220",
"US-2018-3857264",
"CN-2018-4054371"
]
},
{
"fieldName": "order_date",
"type": "string",
"role": "dimension",
"domain": [
"2019/4/27",
"2019/6/15",
"2019/6/16",
"2019/12/9",
"2018/5/31",
"2017/10/27",
"2016/12/22",
"2019/6/1",
"2017/6/5",
"2018/11/22",
"2019/10/2",
"2019/10/3",
"2018/6/7",
"2019/12/12",
"2019/9/28",
"2018/11/19",
"2018/2/28",
"2018/9/3",
"2018/9/17",
"2018/7/2"
]
},
{
"fieldName": "delivery_date",
"type": "string",
"role": "dimension",
"domain": [
"2019/4/29",
"2019/6/16",
"2019/6/19",
"2019/12/10",
"2018/6/2",
"2017/10/31",
"2016/12/24",
"2019/6/6",
"2017/6/9",
"2018/11/25",
"2019/10/3",
"2019/10/4",
"2019/10/5",
"2018/6/14",
"2019/12/15",
"2019/10/2",
"2018/11/23",
"2018/3/1",
"2018/9/6",
"2018/9/21"
]
},
{
"fieldName": "delivery_method",
"type": "string",
"role": "dimension",
"domain": [
"二级",
"标准级",
"一级",
"当日"
]
},
{
"fieldName": "customer_id",
"type": "date",
"role": "dimension",
"domain": [
"曾惠-14485",
"许安-10165",
"宋良-17170",
"万兰-15730",
"俞明-18325",
"谢雯-21700",
"康青-19585",
"赵婵-10885",
"刘斯-20965",
"白鹄-14050",
"贾彩-10600",
"马丽-15910",
"宋栋-12310",
"巩虢-13495",
"常松-20575",
"田黎-16450",
"谭乐-17815",
"徐岱-11875",
"武杰-14815",
"吕兰-15700"
]
},
{
"fieldName": "customer_name",
"type": "string",
"role": "dimension",
"domain": [
"曾惠",
"许安",
"宋良",
"万兰",
"俞明",
"谢雯",
"康青",
"赵婵",
"刘斯云",
"白鹄",
"贾彩",
"马丽",
"宋栋",
"巩虢",
"常松",
"田黎明",
"谭乐",
"徐岱",
"武杰",
"吕兰"
]
},
{
"fieldName": "customer_type",
"type": "string",
"role": "dimension",
"domain": [
"公司",
"消费者",
"小型企业"
]
},
{
"fieldName": "city",
"type": "string",
"role": "dimension",
"domain": [
"杭州",
"内江",
"镇江",
"汕头",
"景德镇",
"榆林",
"哈尔滨",
"青岛",
"徐州",
"上海",
"温岭",
"唐山",
"宁波",
"厦门",
"宿州",
"兰州",
"淮阴",
"肇源",
"南昌",
"合肥"
]
},
{
"fieldName": "province",
"type": "string",
"role": "dimension",
"domain": [
"浙江",
"四川",
"江苏",
"广东",
"江西",
"陕西",
"黑龙江",
"山东",
"上海",
"河北",
"福建",
"安徽",
"甘肃",
"吉林",
"辽宁",
"湖北",
"河南",
"湖南",
"北京",
"重庆"
]
},
{
"fieldName": "country_or_region",
"type": "string",
"role": "dimension",
"domain": [
"中国"
]
},
{
"fieldName": "area",
"type": "string",
"role": "dimension",
"domain": [
"华东",
"西南",
"中南",
"西北",
"东北",
"华北"
]
},
{
"fieldName": "product_id",
"type": "date",
"role": "dimension",
"domain": [
"办公用-用品-10002717",
"办公用-信封-10004832",
"办公用-装订-10001505",
"办公用-用品-10003746",
"办公用-器具-10003452",
"技术-设备-10001640",
"办公用-装订-10001029",
"家具-椅子-10000578",
"办公用-纸张-10001629",
"办公用-系固-10004801",
"技术-设备-10000001",
"技术-复印-10002416",
"办公用-信封-10000017",
"技术-配件-10004920",
"技术-电话-10004349",
"办公用-器具-10003582",
"办公用-标签-10004648",
"技术-配件-10001200",
"办公用-用品-10000039",
"办公用-装订-10004589"
]
},
{
"fieldName": "product_type",
"type": "string",
"role": "dimension",
"domain": [
"办公用品",
"技术",
"家具"
]
},
{
"fieldName": "product_sub_type",
"type": "string",
"role": "dimension",
"domain": [
"用品",
"信封",
"装订机",
"器具",
"设备",
"椅子",
"纸张",
"系固件",
"复印机",
"配件",
"电话",
"标签",
"书架",
"用具",
"收纳具",
"美术",
"桌子"
]
},
{
"fieldName": "product_name",
"type": "string",
"role": "dimension",
"domain": [
"Fiskars 剪刀, 蓝色",
"GlobeWeis 搭扣信封, 红色",
"Cardinal 孔加固材料, 回收",
"Kleencut 开信刀, 工业",
"KitchenAid 搅拌机, 黑色",
"柯尼卡 打印机, 红色",
"Ibico 订书机, 实惠",
"SAFCO 扶手椅, 可调",
"Green Bar 计划信息表, 多色",
"Stockwell 橡皮筋, 整包",
"爱普生 计算器, 耐用",
"惠普 墨水, 红色",
"Jiffy 局间信封, 银色",
"SanDisk 键区, 可编程",
"诺基亚 充电器, 蓝色",
"KitchenAid 冰箱, 黑色",
"Novimex 圆形标签, 红色",
"Memorex 键盘, 实惠",
"Acme 尺子, 工业",
"Avery 孔加固材料, 耐用"
]
},
{
"fieldName": "sales",
"type": "float",
"role": "measure",
"domain": [
29.4,
35621.355
]
},
{
"fieldName": "amount",
"type": "int",
"role": "measure",
"domain": [
1,
14
]
},
{
"fieldName": "discount",
"type": "float",
"role": "measure",
"domain": [
0,
0.8
]
},
{
"fieldName": "profit",
"type": "float",
"role": "measure",
"domain": [
-4988.2,
7214.76
]
}
]