Hi, i'm trying to do the following using Kibana 5.6.5 and VEGA Visualizations;
I have an Elasticsearch query, which will give results for multiple buckets, each contains sub buckets with unique values.
For example, consider Country and States
"buckets": [
{
"key": "USA",
"doc_count": 15
"States": {
"buckets": [
{
"key": "New York",
"doc_count": 10
},
{
"key": "Texas",
"doc_count": 5
}
]
},
},
{
"key": "Canada",
"doc_count": 75
"States": {
"buckets": [
{
"key": "Ontario",
"doc_count": 23
},
{
"key": "Alberta",
"doc_count": 52
}
]
},
}
]
We would like to generate a 'Text Mark' visualization, which will be a hyperlink for each main bucket (Country), containing the concatenated sub bucket values (States), like below.
USA (New York, Texas) >>
Canada (Ontario, Alberta) >>
I have tried using 'transforms' and 'signals' to bind the data to the 'Text Mark', but was not successful.
Appreciate any help on this.
Thanks