# Display count of tomcat down -metric visualization
**URL:** https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477
**Category:** Kibana
**Created:** [March 11, 2022, 4:03pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477 "2022-03-11T16:03:01Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [March 11, 2022, 4:03pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/1 "2022-03-11T16:03:01Z")
Trying to create a visulization in kibana that should only display no of tomcat which are down.
I guess I'm using wrong aggregation and not getting exactly wht can help out here.
'''''''''''''''''
logs:
Filelds:
1)tomcat.host\_name:kpti001,kpti002..etc
2)tomcat.server\_status : "UP" or "Down" Value
'''''''''''''''''''
Issue: when tomcat goes down the count shows correct and updates on visualization,ex 2 tomcat down--metric shows "2",but when server is up it takes 15 min to show current status of UP.
The timefilter is 15 min,but refresh is set 10 s,still not getting how come its updating the value after 15 min,though in discover index the status comes up immediately as "UP".I guess the Unique count and count aggregation are causing it but wht could solve this,any diff aggregation?
Thanks,
Prashant
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [March 14, 2022, 1:01pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/2 "2022-03-14T13:01:03Z")
Hi @PRASHANT_MEHTA. I believe you only want to check the latest status of the Tomcat server. So you might try settings your Metrics to Top Hit on the @timestamp field.
---
### Author:  [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [March 14, 2022, 2:07pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/3 "2022-03-14T14:07:53Z")
## hello @nickpeihl ,thanks for looking into this,I want the total count of tomcat that are down. Ex:Server 1-Tomcat1,Server 2-Tomcat 2...Server n Tomcat n,Now suppose out of active 25 tomcat,5 tomcat goes down so I want 5 to be displayed real time i.e current status.I did tried the Top hit earlier but it didn't worked.Just want the count of host that are presently down.This is something admin will check for real time to check the status.Any suggestion would be helpful. Sample Logs Image: tomcat.server\_status: "UP" or "Down" tomcat.tomcat.host\_name:td06app1001,td02app1002,td03app1003... Kibana 7.9.1
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [March 14, 2022, 2:30pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/4 "2022-03-14T14:30:31Z")
Hi again @PRASHANT_MEHTA. I believe you need to have a terms query for the top hit (on `@timestamp`) for each server then count the results. You might want to use the advanced features of [TSVB](https://www.elastic.co/guide/en/kibana/current/tsvb.html) for that.
---
### Author:  [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [March 14, 2022, 3:45pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/5 "2022-03-14T15:45:44Z")
@nickpeihl Thanx for your quick response!! 😃,I achieved the desired result.Many Thanx.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 11, 2022, 3:46pm UTC](https://discuss.elastic.co/t/display-count-of-tomcat-down-metric-visualization/299477/6 "2022-04-11T15:46:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.