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