# Counting records missing from one month to another

**URL:** <https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488>\
**Category:** Kibana\
**Created:** [July 24, 2022, 7:42pm UTC](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488 "2022-07-24T19:42:59Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![olivierl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierl/32/108769_2.png) [@olivierl](https://discuss.elastic.co/u/olivierl)\
**Post date:** [July 25, 2022, 9:35pm UTC](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488/21 "2022-07-25T21:35:31Z")

</div>

No problem, I can create that index 🙂 And what kind of pivot would you suggest?

---

<div class="post-metadata">

**Author:** ![olivierl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierl/32/108769_2.png) [@olivierl](https://discuss.elastic.co/u/olivierl)\
**Post date:** [July 26, 2022, 7:23am UTC](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488/22 "2022-07-26T07:23:26Z")

</div>

A non-perfect but working solution is to use a Lens with 2 layers (one unique count of emails from the original index, and one with count of my emails that are churn).

Doing a bar vertical percentage will do the computation from me (so the visualization isn't great but I have the result in %). If this is doable via a visualization, I assume I should make it another way 🤔

---

<div class="post-metadata">

**Author:** ![olivierl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierl/32/108769_2.png) [@olivierl](https://discuss.elastic.co/u/olivierl)\
**Post date:** [August 1, 2022, 7:38pm UTC](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488/23 "2022-08-01T19:38:49Z")

</div>

It's not perfect but enough for me (except if someone got a better idea).

How about a similar concept to detect… new customers? Since the "latest" transform will find me the latest record (which is fine for leaving customers in a month), what would be the best approach to detect the fresh new customers per month?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 29, 2022, 7:39pm UTC](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488/24 "2022-08-29T19:39:46Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

[Previous page](https://discuss.elastic.co/t/counting-records-missing-from-one-month-to-another/310488.md?page=1)