I want apply different filters to each column

Elastic Stack Kibana
1

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 :slightly_smiling_face:

image
image.png1264×342 25.6 KB

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?

2

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.)