# Using Lens Table to Keep Track of Days of the Month

**URL:** <https://discuss.elastic.co/t/using-lens-table-to-keep-track-of-days-of-the-month/327597>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [March 13, 2023, 9:11pm UTC](https://discuss.elastic.co/t/using-lens-table-to-keep-track-of-days-of-the-month/327597 "2023-03-13T21:11:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Goishin](https://avatars.discourse-cdn.com/v4/letter/g/46a35a/32.png) [@Goishin](https://discuss.elastic.co/u/Goishin)\
**Post date:** [March 13, 2023, 9:11pm UTC](https://discuss.elastic.co/t/using-lens-table-to-keep-track-of-days-of-the-month/327597/1 "2023-03-13T21:11:08Z")

</div>

I use a Kibana dashboard to keep track of a number of things on my team. We all look at this dashboard to see the team's current status of stuff. But our team also has regular things that happen on specific days of the month. These all happen every month. I now want a table that shows these events for the month, and that day of the month has passed.  
Like so:  
Event\_1 X  
Event\_2 X  
Event\_3  
Event\_4  
Event\_5  
See how in the example above the first two events have X marks next to them? That's kinda what I'm looking for. I have the following data on the events in ES:

```auto
{
    "name": keyword,
    "day_of_month": long
}

```

My question is: Using Lens: how do I add a column in a table such that when "day\_of\_month" is equal to or less than the current day of the month, I display one word, but when the current day of the month is greater than that value, I display a different word?

---

<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:** [April 10, 2023, 9:11pm UTC](https://discuss.elastic.co/t/using-lens-table-to-keep-track-of-days-of-the-month/327597/2 "2023-04-10T21:11:44Z")

</div>

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