# Filter Data in Kibana Dashboard

**URL:** https://discuss.elastic.co/t/filter-data-in-kibana-dashboard/212225
**Category:** Kibana
**Created:** [December 17, 2019, 8:33pm UTC](https://discuss.elastic.co/t/filter-data-in-kibana-dashboard/212225 "2019-12-17T20:33:05Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![aahtysh2525](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@aahtysh2525](https://discuss.elastic.co/u/aahtysh2525)
#### Post date: [December 17, 2019, 8:33pm UTC](https://discuss.elastic.co/t/filter-data-in-kibana-dashboard/212225/1 "2019-12-17T20:33:05Z")

</div>

I am injecting values trough MQTTbeats--\>Logstash---\>ElasticSearch----\>Kibana

I want to get separate values for "Simulation Examples.Functions.Ramp2" and "Simulation Examples.Functions.Random4 tags " as specified in "V" parameter.

When using a table (or any visualization) "mqtt.message.fields.values.v" is available in Terms, but this doesnt give me individual values for "Simulation Examples.Functions.Ramp2" and "Simulation Examples.Functions.Random4" tags

The received json in Kibana is as below

event.module:mqtt event.dataset:mqtt.topic metricset.name:topic service.type:mqtt agent.id:b53c8745-9fb0-4fbf-836b-30cb2413cc31 agent.version:8.0.agent.ephemeral\_id:5d32e52d-0d90-4090-bc40-326b9470833a agent.hostname:LAPTOP-9B1F737E agent.type:machinebeat mqtt.isSystemTopic:false  
mqtt.message.fields.values:  
{ "id": "Simulation Examples.Functions.Random4", "v": -814, "t": 1576612655382, "q": true },  
{ "id": "Simulation Examples.Functions.Ramp2", "t": 1576612655382, "v": 186, "q": true },  
{ "id": "Simulation Examples.Functions.Random4", "v": -24, "t": 1576612656387, "q": true },  
{ "id": "Simulation Examples.Functions.Ramp2", "v": 185.25, "t": 1576612656387, "q": true },  
{ "id": "Simulation Examples.Functions.Random4", "v": -785, "t": 1576612657390, "q": true },

Please help.  
Thanks in advance.

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [December 17, 2019, 11:23pm UTC](https://discuss.elastic.co/t/filter-data-in-kibana-dashboard/212225/2 "2019-12-17T23:23:09Z")

</div>

Ok, if I understand correctly, you're trying to see the values of `v`, grouped by `id`?

You should just have to create a terms agg on the `id` field first, and then add a sub-bucket under that with a terms agg on the `v` field. It would look like this:

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

---

<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: [January 14, 2020, 11:23pm UTC](https://discuss.elastic.co/t/filter-data-in-kibana-dashboard/212225/3 "2020-01-14T23:23:18Z")

</div>

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