Average per month

[QlikBeginner1]

Hello,

I was trying to work out the average per month calculation.

Records live as at each month end during the reporting period ÷ number of months in period.

I have tried this but not sure its what I want to achieve as the numbers dont look correct.

Avg(Aggr(Count(Record), RecordLiveDate, ProductName))

The reporting month is only from 1/7/2021 and 31/21/2021 .

Thanks in advance!!

[tm_burgers]

How do you determine which records are Live @ MonthEnd. Do you only pull the Record at month end each month? and only if it is Live?