# Clickable URL kibana 7.11

**URL:** <https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476>\
**Category:** Kibana\
**Created:** [April 7, 2021, 1:54pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476 "2021-04-07T13:54:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chaimaa\_ABD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaimaa_abd/32/86719_2.png) [@Chaimaa\_ABD](https://discuss.elastic.co/u/Chaimaa_ABD)\
**Post date:** [April 7, 2021, 1:54pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/1 "2021-04-07T13:54:15Z")

</div>

How to display a field as a clickable URL in data table visualization in kibana 7.11 ?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c31b3ee7ff88b0ab2e8fd2da2cc9ef63b9d00682.png)  
I tried to format the field but it doesn't work

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 7, 2021, 3:49pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/2 "2021-04-07T15:49:41Z")

</div>

I was able to create a test document using the Kibana Dev Tools:

```auto
POST test/_doc
{
  "link": "https://www.google.com"
}

```

Then create an Index Pattern for that index, and add the Url format for the "link" field:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/f/8fc592a82d590af1ca13ea2c4bc08b75b2d52831.png)

And then create a Data Table to display the "link" field:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/7/87c6537ba514ecca9cafdca61bad8ba029e89088.png)

Perhaps the problem you are running into is how you are including your "Link" field in your data table? Can you share a screenshot of your data table and the relevant metric?

---

<div class="post-metadata">

**Author:** ![Chaimaa\_ABD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaimaa_abd/32/86719_2.png) [@Chaimaa\_ABD](https://discuss.elastic.co/u/Chaimaa_ABD)\
**Post date:** [April 8, 2021, 8:43am UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/3 "2021-04-08T08:43:16Z")

</div>

Hello Joe,

Thank you for your answer

i tried the example you did and this is the result i get

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/c/dcba2123761e750d3865dd5ed85fd0134367a46e.png)

and in my case this is the result i get

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/0/c0620b94c9ff21b40cec39a1d4aea95724b5a094.png)

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 8, 2021, 2:26pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/4 "2021-04-08T14:26:31Z")

</div>

Ah,

1. You aren't using a regular (aggregation-based) Data Table Visualization, you are using a Lens Visualization.
2. In my example, the URL format is not applied to the `link.keyword` field, it is applied to the `link` field. These are actually two completely different fields ([source](https://www.elastic.co/blog/strings-are-dead-long-live-strings)).

I tried this example in Lens and it wouldn't let me select the `link` field, I chatted with a Lens developer and it is intentional/known but also a limitation. I opened a GitHub issue for that here: [Lens only shows keyword fields, not text fields · Issue #96576 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/96576)

I used 7.11.2 and tried setting `link.keyword` to use the URL format and create a Lens for it, but Lens still didn't render it properly. I also tried it in 7.12.0 and it works fine in that version. I did not find a closed GitHub issue for that -- it is clearly a bug in 7.11.1 but it is fixed in 7.12.0 and onward, perhaps as a side effect of some other changes.

So, you have two options here:

1. Use an aggregation-based Data Table Visualization (Create new Visualization -\> Aggregation based -\> Data table)
2. Upgrade to 7.12.0, which will allow you to use a Lens Visualization for this

---

<div class="post-metadata">

**Author:** ![Chaimaa\_ABD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaimaa_abd/32/86719_2.png) [@Chaimaa\_ABD](https://discuss.elastic.co/u/Chaimaa_ABD)\
**Post date:** [April 8, 2021, 3:34pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/5 "2021-04-08T15:34:17Z")

</div>

Hello Joe,

Thank you for you answer

I tried to use an aggregation-based Data Table Visualization for the two examples  
but i can't find any list of fields

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/9/49e2052c2972f4bea589d6ee233a7783afdd2324.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/8/3828198efd470883586c8470efef459a0b5e181c.png)

Thank you for your help

---

<div class="post-metadata">

**Author:** ![jportner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jportner/32/75692_2.png) [@jportner](https://discuss.elastic.co/u/jportner)\
**Post date:** [April 8, 2021, 3:47pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/6 "2021-04-08T15:47:52Z")

</div>

You need to click "Metric Count" and change it to use the "Top Hit" Aggregation with your desired field 😄

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 6, 2021, 3:48pm UTC](https://discuss.elastic.co/t/clickable-url-kibana-7-11/269476/7 "2021-05-06T15:48:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
