# Metric / Visual Builder: how to configure the builder to aggregate the target data set **URL:** \ **Category:** Kibana\ **Created:** [June 20, 2017, 8:51pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160 "2017-06-20T20:51:53Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![narschang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/narschang/32/20178_2.png) [@narschang](https://discuss.elastic.co/u/narschang)\ **Post date:** [June 20, 2017, 8:51pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/1 "2017-06-20T20:51:54Z")
I am trying to create visualization using the Visual Builder introduced in Kibana 5.4. After I specify the target index, I have problems setting up the filter to get my target data. Does the panel filter under Panel Options follow the same query language/rule when query the data through discovery? Is there a how-to guide about visual builder available? I really want to use this feature but I am stuck with the very basic stuff. Appreciate all helps. Thanks. ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [June 21, 2017, 5:38pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/2 "2017-06-21T17:38:11Z")
The best source of info is the documentation: [https://www.elastic.co/guide/en/kibana/current/time-series-visual-builder.html](https://www.elastic.co/guide/en/kibana/current/time-series-visual-builder.html) When you go a few sections deep into the documentation, you can see that filters are configured in the "Group By" controls: [https://www.elastic.co/guide/en/kibana/current/\_interface\_overview.html#\_group\_by\_controls](https://www.elastic.co/guide/en/kibana/current/_interface_overview.html#_group_by_controls) You can filter all your data by a single filter (choose "Filter" under "Group By") or multiple (choose "Filters"). You use the same Lucene expression syntax for these filters as you can anywhere else in Kibana. Here's a simple example of multiple filters on some Metricbeat data: ![](https://us1.discourse-cdn.com/elastic/original/3X/6/c/6c8a55f7de58ec8c5265edb6d7aa3f140bd615dc.png) The filter control under "Panel Options" is for configuring the entire panel, which could be multiple visualization, instead of just a data series. See [https://www.elastic.co/guide/en/kibana/current/\_interface\_overview.html#\_panel\_options\_tab](https://www.elastic.co/guide/en/kibana/current/_interface_overview.html#_panel_options_tab) Here's an example of using a filter from Panel Options on the Metricbeat data: ![](https://us1.discourse-cdn.com/elastic/original/3X/9/6/96f656a853ea58f0b7ea34655d1167514472fdde.png) Another good source of information for getting started with the Time Series Visual Builder is the blog article: [https://www.elastic.co/blog/master-time-with-kibanas-new-time-series-visual-builder](https://www.elastic.co/blog/master-time-with-kibanas-new-time-series-visual-builder) . There's a demo video there from the creator of the feature. ---
**Author:** ![narschang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/narschang/32/20178_2.png) [@narschang](https://discuss.elastic.co/u/narschang)\ **Post date:** [June 29, 2017, 2:29pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/3 "2017-06-29T14:29:02Z")
Thanks. I am reading the documentation. I might come back if there are any further questions. ---
**Author:** ![narschang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/narschang/32/20178_2.png) [@narschang](https://discuss.elastic.co/u/narschang)\ **Post date:** [July 18, 2017, 8:59pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/4 "2017-07-18T20:59:48Z")
Hello Tim, Thanks for the documentation. I tried, and it didn't work for me. ☹ I just updated to Kibana 5.5 yesterday. What I tried to display is the value from a field called **udppm\_cpu** under the following conditions: Panel options: 1. Index name: **systest\_db-** 2. Time field: **@ timestamp** (to display the latest value based on when the data is ingested into Elasticsearch.) 3. Panel filter: **apl\_name:"mercury"** (the udppm\_cpu usage of the appliance called Mercury.) ![](https://us1.discourse-cdn.com/elastic/original/3X/c/f/cf4c81c76fa9cde333885a0d8831cc4db53b6f99.png) Under Data: 4. Labeled the field as udppm cpu (the label didn't even come up in the display) 5. Metrics/Aggregation: Max (I tried every one of the aggregation, none of them worked) 6. Metrics/Field: udppm\_cpu 7. Metrics/Group by Terms; by udppm\_cpu; Top: 1; order by max of udppm\_cpu. ![](https://us1.discourse-cdn.com/elastic/original/3X/2/4/24604fa0f6a3cc0f4ca7b820e1e624e30eb4f017.png) I can see the visualizations available in the visual builder can really help us create a kick ass dashboard. I just couldn't get it work. I appreciate if you can help me figure out what I did wrong here. Thanks a lot. Regards, Nars ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [July 19, 2017, 7:59pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/5 "2017-07-19T19:59:50Z")
I recommend going one step at a time. - Do you see anything if you don't enter a panel filter? If not, then something could be wrong with your index name or time field. - Do you see anything if you start with a Time Series chart? Looking there first may help to make sure the data you expect to see is coming up correctly in the query. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 16, 2017, 8:00pm UTC](https://discuss.elastic.co/t/metric-visual-builder-how-to-configure-the-builder-to-aggregate-the-target-data-set/90160/6 "2017-08-16T20:00:06Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.