# Kibana Visualization with "filters" on metric **URL:** \ **Category:** Kibana\ **Created:** [August 26, 2019, 7:37am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725 "2019-08-26T07:37:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Post date:** [August 26, 2019, 7:37am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/1 "2019-08-26T07:37:31Z")
hi , i have 4m documents on my kibana and i want to visualise some with "metric count" , all fields of my document have "string" values. I have a CS-Method field and it returns GET or POST string value. I tried to do a metric visualization and choose "filters" aggregation on bucket and typed CS-Method : GET when i do this on discover it returns 2.6m documents but in metric is always 0. Do you guyz have recommandation for this ? thx. ---
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [August 26, 2019, 8:54am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/2 "2019-08-26T08:54:59Z")
Hi Anita, can you please share the filters queries you are using? There can be maybe an issue with the query syntax Can you also please share the the request created by the visualization (click on Inspect from the top nav bar, switch to requests and copy the request to ES (please hide/remove any sensitive data here) ---
**Author:** ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Post date:** [August 26, 2019, 10:18am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/3 "2019-08-26T10:18:12Z")
![1](https://us1.discourse-cdn.com/elastic/original/3X/1/4/145f2d4b6441cbea5b98a274380e948b8eadf681.png) ![2](https://us1.discourse-cdn.com/elastic/original/3X/7/9/79d781dfe0c643e6135a2fe2a570fccb0eb85f46.png) i tried like these but it might be wrong 🙂 ---
**Author:** ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Post date:** [August 26, 2019, 10:23am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/4 "2019-08-26T10:23:57Z")
My request is like this by the way ``` "aggs": { "2": { "filters": { "filters": { "CS-Method : GET": { "bool": { "must": [], "filter": [ { "bool": { "should": [ { "match": { "CS-Method": "GET" } } ], "minimum_should_match": 1 } } ], "should": [], "must_not": [] } } } } } }, "size": 0, "_source": { "excludes": [] }, "stored_fields": [ "*" ], "script_fields": {}, "docvalue_fields": [ { "field": "@timestamp", "format": "date_time" } ], "query": { "bool": { "must": [ { "range": { "@timestamp": { "format": "strict_date_optional_time", "gte": "2019-08-26T09:56:05.055Z", "lte": "2019-08-26T10:11:05.055Z" } } } ], "filter": [ { "match_all": {} } ], "should": [], "must_not": [] } } } ``` ---
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [August 26, 2019, 10:39am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/5 "2019-08-26T10:39:48Z")
The query seems ok but to be sure could you please change the `Filter 1` as `CS-Method.keyword : "GET"` The CS-Method field should be mapped as keyword also. It should works also the way you have wrote it's worth a try. From the request seems that you are requesting a 15 min interval, are you sure you have data on that interval? Maybe it's worth trying a larger interval ---
**Author:** ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Post date:** [August 26, 2019, 10:43am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/6 "2019-08-26T10:43:57Z")
oh thank you Marco , i changed the time interval and it works i have few questions if posibble 🙂 1- Do i need to refresh allways the time interval when i open the dashboard if i use this "metric visualise" or will be automatic ? 2- Will this technique work when i try to draw other charts like line bar ? (techinque i mean if i want to draw chart using string values) ---
**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\ **Post date:** [August 26, 2019, 10:47am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/7 "2019-08-26T10:47:41Z")
The time picker value persistent across Discover, Visualize and Dashboard app, so if you change it on a visualization, it will be the same when switching to the dashboard. If your index have a time field (and the index-pattern is configured with that time field, by default it is) than your queries are "time-sensitive", meaning that the results always depends on the time interval chosen. ---
**Author:** ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)\ **Post date:** [August 26, 2019, 10:48am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/8 "2019-08-26T10:48:51Z")
Thank you. You are best 🤗 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 23, 2019, 10:48am UTC](https://discuss.elastic.co/t/kibana-visualization-with-filters-on-metric/196725/9 "2019-09-23T10:48:55Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.