# I want apply different filters to each column

**URL:** https://discuss.elastic.co/t/i-want-apply-different-filters-to-each-column/160322
**Category:** Kibana
**Created:** [December 11, 2018, 8:34am UTC](https://discuss.elastic.co/t/i-want-apply-different-filters-to-each-column/160322 "2018-12-11T08:34:51Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![AnKyoung](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@AnKyoung](https://discuss.elastic.co/u/AnKyoung)
#### Post date: [December 11, 2018, 8:34am UTC](https://discuss.elastic.co/t/i-want-apply-different-filters-to-each-column/160322/1 "2018-12-11T08:34:51Z")

</div>

Hello Community,

I make some data table.

There is one problem: upload and login have the same count values.

I want to apply different filters to each column, but I don't fount how apply diiferent filters to each column

like this 🙂

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/2/126f83bcf93466e7f09216416fc9f15e63036a91.png)

upload, login is different means.  
so I want to make the upload and login count values into values in different fields.

like this:  
upload column  
{  
"query": {  
"match": {  
"Operation": {  
"query": "upload",  
"type": "phrase"  
}  
}  
}  
}

login column  
{  
"query": {  
"match": {  
"Status": {  
"query": "Login",  
"type": "phrase"  
}  
}  
}  
}

Can anyone help me?

---

<div class="post-metadata">

### Author: ![Sjaak01](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)
#### Post date: [December 12, 2018, 3:06am UTC](https://discuss.elastic.co/t/i-want-apply-different-filters-to-each-column/160322/2 "2018-12-12T03:06:06Z")

</div>

Which metrics did you select for upload and login?

If you do something like SUM for both upload and login and then under buckets select term -\> userid and another term for you timestamp then you should be able to see the total of upload and login for each userid for a operationdate.

Of course you can change the metrics to make it show the actual data you need (count, average, etc.)

---

<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 9, 2019, 3:06am UTC](https://discuss.elastic.co/t/i-want-apply-different-filters-to-each-column/160322/3 "2019-01-09T03:06:08Z")

</div>

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