I am having a problem using Redash to visualize ES data.
Here is the format of response returned by ES:
{
"took": 225,
"timed_out": false,
"_shards": {
...
},
"hits": {
"total": {
...
},
"max_score": null,
"hits": [
{
...
"_source": {
"data": {
"mobile": 1,
"label": "Test",
"completed": 1234561,
"id": "2002",
"url": "http://www.example.com/",
"average": {
"firstView": {
"loadTime": 1234
}
},
...
}
},
...
},
...
]
}
}
t seems that Redash can only view the “data” JSON object as a whole, rather than extract detail children information of “data” object, which make Redash cannot successfully visualize the response (say, based on completed and loadTime).
Thus, is there a way to visualize this type of data format? Thanks.