1. We have below logic in our analysis which is evaluating 1st day of the month at 00:00 but we want to evaluate it to 2nd day of the month at 00:00. How can I change it so that it will evaluate as per the requirement?

2. By default current calculation is multiplying with 31 days but we want to multiply with number of days in a month. Because of this calculation we are getting wrong results for months which are having 28 or 29 or 30 days in a month.

You can use TagMean() for event weighted average. For event weighted totals you could use TagMean() * EventCount() though this isn't a perfect solution. The best solution is to upgrade

Hi Seb Sebastien Raposo,

1. We have below logic in our analysis which is evaluating 1st day of the month at 00:00 but we want to evaluate it to 2nd day of the month at 00:00. How can I change it so that it will evaluate as per the requirement?

2. By default current calculation is multiplying with 31 days but we want to multiply with number of days in a month. Because of this calculation we are getting wrong results for months which are having 28 or 29 or 30 days in a month.

Kindly help me.

Thanks,

Mallesh