# Create data table with url contains word

**URL:** https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857
**Category:** Kibana
**Created:** [July 5, 2017, 8:26am UTC](https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857 "2017-07-05T08:26:26Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sonnguyenit](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@sonnguyenit](https://discuss.elastic.co/u/sonnguyenit)
#### Post date: [July 5, 2017, 8:26am UTC](https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857/1 "2017-07-05T08:26:27Z")

</div>

I'm newer from Kibana.  
I need to create a data table to view count url matching some word.

Example i want to count all url contains "chinh-tri".  
So i type "chinh-tri" at the include field. But no data show.  
Event i change it to "%chinh-tri%", so the result was 0.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/b/3/b3b2072954de1bc4d7a064d7b4eb7908055ee65b.png)

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [July 5, 2017, 8:24pm UTC](https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857/2 "2017-07-05T20:24:01Z")

</div>

If you look at the docs for the [Elasticsearch terms aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html), you'll notice that you actually have to do `.*` instead of `%`, like this: `.*chinh-tri.*`. Could you give that a try?

---

<div class="post-metadata">

### Author: ![sonnguyenit](https://avatars.discourse-cdn.com/v4/letter/s/e95f7d/32.png) [@sonnguyenit](https://discuss.elastic.co/u/sonnguyenit)
#### Post date: [July 6, 2017, 9:42am UTC](https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857/3 "2017-07-06T09:42:58Z")

</div>

thanks @lukas. It looks like work well.

---

<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: [August 3, 2017, 9:43am UTC](https://discuss.elastic.co/t/create-data-table-with-url-contains-word/91857/4 "2017-08-03T09:43:22Z")

</div>

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