I am running a path_hierarchy
tokenizer query:
{
"index": "file_path_timeseries",
"aggs": {
"tree": {
"path_hierarchy": {
"script": "doc['date'].value.toOffsetDateTime().format(DateTimeFormatter.ofPattern('yyyy/MM/dd'))",
"order": {
"_key": "asc"
},
"size": 100
}
}
}
}
The results from Kibana
look like this:
{
"took" : 2,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 13,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"tree" : {
"buckets" : [
{
"key" : "2020",
"doc_count" : 13,
"path" : [ ],
"tree" : {
"buckets" : [
{
"key" : "01",
"doc_count" : 12,
"path" : [
"2020"
],
"tree" : {
"buckets" : [
{
"key" : "10",
"doc_count" : 2,
"path" : [
"2020",
"01"
]
},
{
"key" : "11",
"doc_count" : 5,
"path" : [
"2020",
"01"
]
},
{
"key" : "12",
"doc_count" : 3,
"path" : [
"2020",
"01"
]
},
{
"key" : "13",
"doc_count" : 2,
"path" : [
"2020",
"01"
]
}
]
}
},
{
"key" : "02",
"doc_count" : 1,
"path" : [
"2020"
],
"tree" : {
"buckets" : [
{
"key" : "02",
"doc_count" : 1,
"path" : [
"2020",
"02"
]
}
]
}
}
]
}
}
]
}
}
}
The results from redash only return doc_count 13
and tree 2020
. Is it possible to show all of the response in redash so I can make visualizations?
Any help appreciated, cheers!