Days per month in a group 1

[bartsimpson]

I need to do some calculations on data for a number of months, based on the number of days in the month.
For example, if I have 3 events in january, then I would have a figure of 3 / 31 = 0.097. I do this for all of the months in the year, in one report, based on a group by month.

Many people have asked a similar question about the number of days per month, but all are based on a known start date & end date. How do I do this ( using DateDiff, I presume ) when the start and end dates are based on a group, so it's the group that specifies the start date & end date ?

 

[lbass]

Try:

datediff("d",
date(year({table.date}),month({table.date}),01),
dateserial(year({table.date}),month({table.date})+1, 01)-1)

-LB

 

[bartsimpson]

That is beautiful - except you don't need the "-1" at the end.

Many thanks, lbass.

 

[lbass]

Yes, sorry, you're right.

-LB