Page 1 of 1

Dumb question: Getting counts

Posted: Wed Nov 29, 2017 3:47 pm
by bpizzutiWHI
Ok, I might be having a brain fart here. I'm pulling in some error logs, and I need to figure out how to show the number of unique entries over the past 24 hours...not total entries, and not the count of unique entries, I need to know the total count of unique error messages. And I just can't seem to wrap my way around a way to get NLS to show it. Anyone have any thought?

Re: Dumb question: Getting counts

Posted: Wed Nov 29, 2017 5:38 pm
by dwhitfield
I'm not sure I understand the question.

Here are some example logs:
11
12
13
11
11
11
11

Do you want this to report:
A) 3
B) 11 (5), 12 (1), 13, (1) [or more likely, one of those individually]
C) something else?

I think it's pretty clear you don't want it to output 7.

Re: Dumb question: Getting counts

Posted: Thu Nov 30, 2017 9:28 am
by mcapra
Official Kibana documentation, albiet for a newer version, that says "yes you can do that":
https://www.elastic.co/guide/en/kibana/ ... chart.html

I think what you want to add to your dashboard is a "Terms" panel or a "Count" panel; I forget the exact naming of things. In a nutshell, you create a Terms/Count panel, target the specific field you want to look at "unique values" for, then each unique value will be listed with a total count up to whatever limit you set when defining the panel (10 by default I think).

So if you had a bunch of different error codes stored in the ErrorCode field, you could create a panel on your dashboard that lists each unique ErrorCode as well as the number of occurrences. I believe this is what you're looking for?

Hopefully someone staring at an NLS GUI can take things from there :)

Re: Dumb question: Getting counts

Posted: Thu Nov 30, 2017 3:59 pm
by kyang
Thanks @mcapra!

OP, Can you confirm this is what you wanted?

Re: Dumb question: Getting counts

Posted: Fri Feb 02, 2018 11:12 am
by bpizzutiWHI
Sorry to ressurect the zombie thread, I just realized I never got back to this one. In answer to dwhitfield's question, I was looking for the output of 3, yes.

Re: Dumb question: Getting counts

Posted: Fri Feb 02, 2018 4:37 pm
by cdienger
Have you tried adding a panel as @mcapra suggested? I tested on a system and to return a count of the top 4 error codes, it would look like: