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

[przemek_ironcode (Przemek)]

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:

[nickpeihl]

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.