Period mapper
Use the Period mapper tool to map a date column in your data set into a calendar period.
Use the Period mapper tool to map a date column in your data set into a calendar period. This tool adds a new column in row viewer, displaying the time period that your data maps to.
The Period mapper only allows a default of a three-year time period. The tool will default to the three-year mark if you input a date outside that range.
Define the Start date, End date and Period type. Choose from the following calendar period types:
Months: A period of a calendar month, such as 30 days.
Half months: A period of exactly half a calendar month, such as 15 days.
2 week periods: A period of 14 days.
4 week periods: A period of 28 days.
Weekly periods: A period of seven days.
Note
You can switch to different time periods at any time. The Period mapper automatically names the Time period names by default, but you can update these values at any time.
If you have an end date that is less than half the period, the Period mapper combines it into the previous period. If you have an end date that is more than half the period, the Period mapper puts it into a new period.
Any out of range dates appear in the period column as Out of range.
When to use this tool
Use the Period mapper to split your data to aggregate it for analytic purposes. The Period mapper supports a fiscal calendar year, so you can use this to align with your fiscal year.