I have a query for elasticsearch on redash, the result from elasticsearch is:
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 19,
"max_score": 0,
"hits": []
},
"aggregations": {
"moduleId": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "数据",
"doc_count": 11,
"labels": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "数据自身问题",
"doc_count": 10,
"onesId_num": {
"value": 10
}
},
{
"key": "未填写原因",
"doc_count": 1,
"onesId_num": {
"value": 1
}
}
]
}
},
{
"key": "多码后端",
"doc_count": 8,
"labels": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "未填写原因",
"doc_count": 8,
"onesId_num": {
"value": 8
}
}
]
}
}
]
}
}
}
As shown in the above elasticsearch query result, the “数据” key has a sub-buckets contained two keys(“数据自身问题”, “未填写原因”).
But, on redash, the result table just display “未填写原因” for the “数据” key, “数据自身问题” does not display:
Why the row which moduleId is “数据” and labels is “数据自身问题” does not display in the result table?