3 of 3 people found this helpful
You could use bom (beginning of month) along with TagMean (which is event-weighted, versus TagAvg, which is time-weighted) and EventCount to calculate that:
I tried it with the following table:
And got these results:
Hope that helps!
Thanks so much Kelsey. It works perfectly.
That's what I was looking (an event-weighted function).