# How to present score of current month and month -1 at one Lens table

**URL:** <https://discuss.elastic.co/t/how-to-present-score-of-current-month-and-month-1-at-one-lens-table/322306>\
**Category:** Kibana\
**Created:** [January 2, 2023, 11:41am UTC](https://discuss.elastic.co/t/how-to-present-score-of-current-month-and-month-1-at-one-lens-table/322306 "2023-01-02T11:41:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![przemek\_ironcode](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@przemek\_ironcode](https://discuss.elastic.co/u/przemek_ironcode)\
**Post date:** [January 2, 2023, 11:41am UTC](https://discuss.elastic.co/t/how-to-present-score-of-current-month-and-month-1-at-one-lens-table/322306/1 "2023-01-02T11:41:57Z")

</div>

Hello All,

I have a problem displaying data in the Lens table. I want to display the score of the current month, month -1, and the difference between these scores.

Below is a sample table. Thanks in advance for your help

example:

 ![Screenshot from 2023-01-02 12-41-23](https://us1.discourse-cdn.com/elastic/original/3X/7/8/782a0b63104f0c127515098fb7c34020c4e80a3a.png)

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 3, 2023, 2:28pm UTC](https://discuss.elastic.co/t/how-to-present-score-of-current-month-and-month-1-at-one-lens-table/322306/2 "2023-01-03T14:28:53Z")

</div>

Hi Przemek,

In my screenshot below, I used a custom formula, `count(shift='1d')`, to create another column showing the count from the previous day. You should be able to use `shift='1M'` in a similar formula.

 ![lens-formula-shift](https://us1.discourse-cdn.com/elastic/original/3X/7/8/784ae96731aee290f516a1cab3c26fb504010555.jpeg)

---

<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:** [January 31, 2023, 2:29pm UTC](https://discuss.elastic.co/t/how-to-present-score-of-current-month-and-month-1-at-one-lens-table/322306/3 "2023-01-31T14:29:20Z")

</div>

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