I am trying to create a visualize in Kibana which will have a URL which will be formatted using the value in the field something like this:
But I can see the value populated in my field cpp_sonar_url but when I try to format URL with cpp_sonar_url.keyword, it is coming out empty in the "Data table" visualize when aggregated as "terms".
The URL in the dashboard shows something like this(without branch populated):
I have to use .keyword because the visualize only shows the .keyword field and not the actual field.
I have been using the same logic for other fields and it is working fine for them but not for this one so not sure what is different about this and how can I debug it to make it work.
Any pointers will be really helpful.