How to create a calculated month-to-date (MTD) metric?

[raphael_nottebo]

Hello, how would you create a month-to-date (MTD) metric? For instance, if I count 20 conversions on the 15th of the month, my Conversions MTD metric is 40 (assuming the number of days in the current month is 30).

Thanks!

[sanmeetw1519854 · Accepted solution]

Hey Raphael,

MTD is period between start of the month and current date or date under consideration. In this case your MTD will not be 40, it will be 20 only if the date under consideration is 15th.

In case 5 conversions happen on 16th, and the date for MTD is 16th, your MTD will be 25.

Hope this helps.

Regards,

Sanmeet

[Gigazelle]

I'm having trouble understanding where you're getting the 40 from. Can you elaborate on the calculations you use to get that number?