Sum of one common value on two fields

Hi there,

I'm trying to build a visualisation which calculates the sum of one specific value across all my documents filtered by 2 fields.

Here some truncated data to illustrate my words :

{
...
"class": "A",
"value": "5",
"@timestamp": "2020-06-26T13:44:15.741Z",
"message": "A,5,titi",
"words": "titi",
...
}

{
...
"type": "2",
"value": "5",
"@timestamp": "2020-06-26T13:46:07.142Z",
"message": "A,5,titi",
"words": "titi",
...
}

I would like to do :
sum of value where class = "A" and type = "2" -> 10

But I don't know which visualisation should I used

If you have any ideas, I will appreciate your help.

Best,
Kamfart

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