Count Metric Usage

[anchals02]

Hi
I am trying to create a table panel in Grafana. I have an ES index collecting data from DB using Logstash. My actual DB table consist of only 12 rows with status either as COMPLETED or PENDING.

I want to have a table which shows me the number of rows which are completed and number of rows which are pending.
I am doing that as:

Metric: Count
Group By : Terms status.keyword

But on doing this I am getting COMPLETED count as 630 and PENDING count as 7, which sum as the total number of hits in ES.

I am expecting results to be COMPLETED count 8 and PENDING count 4. Sum should never exceed 12 , as there are only 12 rows in my data.

Can you please help where I am going wrong.

[torkel]

maybe you have more documents in ES then you think? ES seems to return 630.

You can check the raw query and raw ES response by using the query inspector (introduced in Grafana v4.6 in metrics tab).

How To Use Grafana's Query Inspector to troubleshoot issues

Query Inspector is a new feature that was added to Grafana v4.5. It shows query requests and responses. This can be helpful if a graph is not shown or shows something very different than what you expected. Depending on the data source the response will look different. The Query Inspector can be found under the metrics tab inside panel edit mode. First you should check and see if there is anything unexpected or wrong in the query Grafana sends to your database or in the response. ex: [imag…

[anchals02]

I have scheduled the logstash config file to run every minute. So it is pushing data every minute into ES. The count I was getting is the sum total of all.

To solve it, the only solution I can see is Override the time to 1m in Time Range of the panel. So that I see the count of last collected data only and not the sum total.

[ahha45]

I have the exact same issue…I get alerts because of the count shows as 0 if I use graph or stat visualisation but in table view I see hundreds of rows with two columns…one with the timestamps and one with “Count” where the value is 0…any help please?