# Get visualization of missing data

**URL:** <https://discuss.elastic.co/t/get-visualization-of-missing-data/251285>\
**Category:** Kibana\
**Created:** [October 7, 2020, 2:20pm UTC](https://discuss.elastic.co/t/get-visualization-of-missing-data/251285 "2020-10-07T14:20:44Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [October 14, 2020, 10:48am UTC](https://discuss.elastic.co/t/get-visualization-of-missing-data/251285/2 "2020-10-14T10:48:08Z")

</div>

Hi, probably one way to do that is:

- create a data table in TSVB
- pick `Entire time range` on the `Data timerange mode` in the Panel options.
- Select the last month as time interval
- specify the group by related to your sources field
- keep the current count metric aggregation
- on the options panel of your count metric aggregation apply a filter: like `@timestamp >= now-48h`

This should basically get all the sources available in the last month but counts the number of documents only for the documents with a timestamp greater than now - 48h. In the table, will appear all your sources with no data in the last 48 hours at 0.  
You can also specify a text color if the metric is at zero

---

_[View the full topic](https://discuss.elastic.co/t/get-visualization-of-missing-data/251285)._