Asssuming your date variable is in a date format, you can do the following:
(If your date is a character, you can create a calculated item and use the parse operator to convert the date to a date type)
Average by Month:
1. Duplicate the date variable, rename to Month Year, and change the format to 'MMMYYYY'
2. Create a calculated item 'Average Population' = Avg [by group] population'
3. Put the Month Year and Average Population in a list table and averages by month will be calculated.
Average by Fiscal Year:
I would recommend adding an extra column in your data indicating which fiscal period that date falls within. For example, if one fiscal year is April 2014 - March 2015, then add an extra column where the fiscal year is 2014 for all those records. Your data should look something like this:
date
population
gender
fiscal year
04Jan2015
395
F
2014
04Jan2015
3052
M
2014
05Apr2015
3143
M
2015
05May2015
397
F
2015
06Jan2016
405
F
2015
06May2016
3120
M
2016
Then, you can use the fiscal year variable and the same average population item created above in another list table and the averages will automatically calculate for the fiscal years.
Hope this helps,
Jaime
... View more
