Calculating the Sum of Count metric in Kibana


(Akhil Kintali) #1

{"Username": A, "Condition":92, "Severity":32}
{"Username": A, "Condition":89, "Severity":65}
{"Username": B, "Condition":92, "Severity":60}
{"Username": B, "Condition":21, "Severity":53}
{"Username": B, "Condition":33, "Severity":65}
{"Username": C, "Condition":94, "Severity":60}
{"Username": C, "Condition":10, "Severity":65}

Above is a sample of my output. How can I get the count of the Usernames A & B? How can I get the count of only Username C?

Any help would be appreciated.


(Peter Pisljar) #2

if you want to get the count of all usernames:

  • create a table visualization
  • as a metric choose Count (already chosen by default)
  • in the bucket aggregation part select the Term aggregation (for splitting rows) and choose the username field

this will produce result like

 username    |    count
 A           |    10
 B           |    12
 C           |    30

now if you want to show only user A, just click on A and it will filter only on that user
you will see a filter added to the filter panel on the top, you can click that filter and EDIT it

in the edit mode you will see something like username is A
you could change the is to is one of and enter A, B to the value field and you will get only the users A and B.

let me know if this helps.

regards, Peter


(system) #3

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