The following table details all of the periods that can be used when using an Interactive Statistics query.
Type | Name | Display Name | Id | Description | Is Scalar? | Is Series? |
---|---|---|---|---|---|---|
Period | 1 Month | 1 Month | 1M | 1 Month | Yes | No |
StartDate | 1 Month | 1M | 1 Month | |||
Period | 1 Open Day | 1 Open Day | 1D | 1 Open Day | Yes | No |
StartDate | 1 Open Day | 1D | 1 Open Day | |||
Period | 1 Week | 1 Week | 1W | 1 Week | Yes | No |
StartDate | 1 Week | 1W | 1 Week | |||
Period | 1 Whole Calendar Month to Date | 1 Whole Calendar Month to Date | 1CM | 1 Whole Calendar Month to Date | Yes | No |
Period | 1 Whole Calendar Week to Date | 1 Whole Calendar Week to Date | 1CW | 1 Whole Calendar Week to Date | Yes | No |
Period | 1 Year | 1 Year | 1Y | 1 Year | Yes | No |
StartDate | 1 Year | 1Y | 1 Year | |||
Period | 2 Months | 2 Months | 2M | 2 Months | Yes | No |
StartDate | 2 Months | 2M | 2 Months | |||
Period | 2 Open Days | 2 Open Days | 2D | 2 Open Days | Yes | No |
StartDate | 2 Open Days | 2D | 2 Open Days | |||
Period | 2 Weeks | 2 Weeks | 2W | 2 Weeks | Yes | No |
StartDate | 2 Weeks | 2W | 2 Weeks | |||
Period | 2 Whole Calendar Months to Date | 2 Whole Calendar Months to Date | 2CM | 2 Whole Calendar Months to Date | Yes | No |
Period | 2 Whole Calendar Weeks to Date | 2 Whole Calendar Weeks to Date | 2CW | 2 Whole Calendar Weeks to Date | Yes | No |
Period | 2 Years | 2 Years | 2Y | 2 Years | Yes | No |
StartDate | 2 Years | 2Y | 2 Years | |||
Period | 3 Months | 3 Months | 3M | 3 Months | Yes | No |
StartDate | 3 Months | 3M | 3 Months | |||
Period | 3 Open Days | 3 Open Days | 3D | 3 Open Days | Yes | No |
StartDate | 3 Open Days | 3D | 3 Open Days | |||
Period | 3 Weeks | 3 Weeks | 3W | 3 Weeks | Yes | No |
StartDate | 3 Weeks | 3W | 3 Weeks | |||
Period | 3 Whole Calendar Months to Date | 3 Whole Calendar Months to Date | 3CM | 3 Whole Calendar Months to Date | Yes | No |
Period | 3 Whole Calendar Weeks to Date | 3 Whole Calendar Weeks to Date | 3CW | 3 Whole Calendar Weeks to Date | Yes | No |
Period | 3 Years | 3 Years | 3Y | 3 Years | Yes | No |
StartDate | 3 Years | 3Y | 3 Years | |||
Period | 4 Months | 4 Months | 4M | 4 Months | Yes | No |
StartDate | 4 Months | 4M | 4 Months | |||
Period | 4 Open Days | 4 Open Days | 4D | 4 Open Days | Yes | No |
StartDate | 4 Open Days | 4D | 4 Open Days | |||
Period | 4 Weeks | 4 Weeks | 4W | 4 Weeks | Yes | No |
StartDate | 4 Weeks | 4W | 4 Weeks | |||
Period | 4 Whole Calendar Quarters to Date | 4 Whole Calendar Quarters to Date | 4CQ | 4 Whole Calendar Quarters to Date | Yes | No |
Period | 4 Years | 4 Years | 4Y | 4 Years | Yes | No |
StartDate | 4 Years | 4Y | 4 Years | |||
StartDate | 5 Full Calendar Years to Date | 5CY | 5 Full Calendar Years to Date | |||
StartDate | 5 Full Fiscal Years to Date | Fiscal.5CY | 5 Full Fiscal Years to Date | |||
Period | 5 Months | 5 Months | 5M | 5 Months | Yes | No |
StartDate | 5 Months | 5M | 5 Months | |||
Period | 5 Open Days | 5 Open Days | 5D | 5 Open Days | Yes | No |
StartDate | 5 Open Days | 5D | 5 Open Days | |||
Period | 5 Whole Calendar Years to Date | 5 Whole Calendar Years to Date | 5CY | 5 Whole Calendar Years to Date | Yes | No |
Period | 5 Years | 5 Years | 5Y | 5 Years | Yes | No |
StartDate | 5 Years | 5Y | 5 Years | |||
Period | 6 Months | 6 Months | 6M | 6 Months | Yes | No |
StartDate | 6 Months | 6M | 6 Months | |||
Period | 6 Years | 6 Years | 6Y | 6 Years | Yes | No |
StartDate | 6 Years | 6Y | 6 Years | |||
Period | 7 Months | 7 Months | 7M | 7 Months | Yes | No |
StartDate | 7 Months | 7M | 7 Months | |||
Period | 7 Years | 7 Years | 7Y | 7 Years | Yes | No |
StartDate | 7 Years | 7Y | 7 Years | |||
Period | 8 Months | 8 Months | 8M | 8 Months | Yes | No |
StartDate | 8 Months | 8M | 8 Months | |||
Period | 8 Years | 8 Years | 8Y | 8 Years | Yes | No |
StartDate | 8 Years | 8Y | 8 Years | |||
Period | 9 Months | 9 Months | 9M | 9 Months | Yes | No |
StartDate | 9 Months | 9M | 9 Months | |||
Period | 9 Years | 9 Years | 9Y | 9 Years | Yes | No |
StartDate | 9 Years | 9Y | 9 Years | |||
StartDate | 10 Full Calendar Years to Date | 10CY | 10 Full Calendar Years to Date | |||
StartDate | 10 Full Fiscal Years to Date | Fiscal.10CY | 10 Full Fiscal Years to Date | |||
Period | 10 Months | 10 Months | 10M | 10 Months | Yes | No |
StartDate | 10 Months | 10M | 10 Months | |||
Period | 10 Whole Calendar Years to Date | 10 Whole Calendar Years to Date | 10CY | 10 Whole Calendar Years to Date | Yes | No |
Period | 10 Whole Fiscal Years to Date | 10 Whole Fiscal Years to Date | Fiscal.10CY | 10 Whole Fiscal Years to Date | Yes | No |
Period | 10 Years | 10 Years | 10Y | 10 Years | Yes | No |
StartDate | 10 Years | 10Y | 10 Years | |||
Period | 11 Months | 11 Months | 11M | 11 Months | Yes | No |
StartDate | 11 Months | 11M | 11 Months | |||
Period | 12 Months | 12 Months | 12M | 12 Months | Yes | No |
StartDate | 12 Months | 12M | 12 Months | |||
Period | 15 Years | 15 Years | 15Y | 15 Years | Yes | No |
StartDate | 15 Years | 15Y | 15 Years | |||
Period | 20 Years | 20 Years | 20Y | 20 Years | Yes | No |
StartDate | 20 Years | 20Y | 20 Years | |||
Period | Calendar Month 1 | Calendar Month 1 | M1 | Month 1 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 2 | Calendar Month 2 | M2 | Month 2 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 3 | Calendar Month 3 | M3 | Month 3 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 4 | Calendar Month 4 | M4 | Month 4 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 5 | Calendar Month 5 | M5 | Month 5 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 6 | Calendar Month 6 | M6 | Month 6 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 7 | Calendar Month 7 | M7 | Month 7 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 8 | Calendar Month 8 | M8 | Month 8 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 9 | Calendar Month 9 | M9 | Month 9 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 10 | Calendar Month 10 | M10 | Month 10 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 11 | Calendar Month 11 | M11 | Month 11 in the same year as the Reporting Date | Yes | No |
Period | Calendar Month 12 | Calendar Month 12 | M12 | Month 12 in the same year as the Reporting Date | Yes | No |
Period | Calendar Months | CalendarMonths | Calendar Months | No | Yes | |
Period | Calendar Months | CalendarWeeks | Calendar Months | No | Yes | |
Period | Calendar Months plus Stub Periods | CalendarMonthsPlusStubs | Calendar Months plus Stub Periods | No | Yes | |
Period | Calendar Quarter 1 | Calendar Quarter 1 | Q1 | Quarter 1 in the same year as the Reporting Date | Yes | No |
Period | Calendar Quarter 2 | Calendar Quarter 2 | Q2 | Quarter 2 in the same year as the Reporting Date | Yes | No |
Period | Calendar Quarter 3 | Calendar Quarter 3 | Q3 | Quarter 3 in the same year as the Reporting Date | Yes | No |
Period | Calendar Quarter 4 | Calendar Quarter 4 | Q4 | Quarter 4 in the same year as the Reporting Date | Yes | No |
Period | Calendar Quarters | CalendarQuarters | Calendar Quarters | No | Yes | |
Period | Calendar Quarters plus Stub Periods | CalendarQuartersPlusStubs | Calendar Quarters plus Stub Periods | No | Yes | |
Period | Calendar Weeks plus Stub Periods | CalendarWeeksPlusStubs | Calendar Weeks plus Stub Periods | No | Yes | |
Period | Calendar Years | CalendarYears | Calendar Years | No | Yes | |
Period | Calendar Years inc. complete Years for Stub Periods | CalendarYearsExtended | Calendar Years inc. complete Years for Stub Periods | No | Yes | |
Period | Calendar Years plus Stub Periods | CalendarYearsPlusStubs | Calendar Years plus Stub Periods | No | Yes | |
EndDate | Close Date | Measure.CloseDate | Close Date | |||
StartDate | Earliest | Earliest | Earliest | |||
EndDate | Feeze Date | Measure.FreezeDate | Feeze Date | |||
Period | Fiscal Year to Date | Fiscal Year to Date | Fiscal.YTD | Fiscal Year to Date | Yes | No |
StartDate | Fiscal Year to Date | Fiscal.YTD | Fiscal Year to Date | |||
StartDate | From start of earliest Fiscal Year | Fiscal.EarliestYearAligned | From start of earliest Fiscal Year | |||
StartDate | From start of earliest Month | EarliestMonthAligned | From start of earliest Month | |||
StartDate | From start of earliest Quarter | EarliestQuarterAligned | From start of earliest Quarter | |||
StartDate | From start of earliest Year | EarliestYearAligned | From start of earliest Year | |||
Period | Full Period | Full Period | FullPeriod | The full unadjusted period. | Yes | No |
Period | Full Period at Table Level | Full Period at Table Level | FullPeriodTable | The full unadjusted period at table level. | Yes | No |
Period | Full Period, Fiscal Month Aligned | Full Period, Fiscal Month Aligned | Fiscal.FullPeriodMonthAligned | The full unadjusted period, fiscal month aligned. | Yes | No |
Period | Full Period, Fiscal Quarter Aligned | Full Period, Fiscal Quarter Aligned | Fiscal.FullPeriodQuarterAligned | The full unadjusted period, fiscal quarter aligned. | Yes | No |
Period | Full Period, Fiscal Week Aligned | Full Period, Fiscal Week Aligned | Fiscal.FullPeriodWeekAligned | The full unadjusted period, fiscal week aligned. | Yes | No |
Period | Full Period, Fiscal Year Aligned | Full Period, Fiscal Year Aligned | Fiscal.FullPeriodYearAligned | The full unadjusted period, fiscal year aligned. | Yes | No |
Period | Full Period, Month Aligned | Full Period, Month Aligned | FullPeriodMonthAligned | The full unadjusted period, month aligned. | Yes | No |
Period | Full Period, Quarter Aligned | Full Period, Quarter Aligned | FullPeriodQuarterAligned | The full unadjusted period, quarter aligned. | Yes | No |
Period | Full Period, Week Aligned | Full Period, Week Aligned | FullPeriodWeekAligned | The full unadjusted period, Week aligned. | Yes | No |
Period | Full Period, Year Aligned | Full Period, Year Aligned | FullPeriodYearAligned | The full unadjusted period, year aligned. | Yes | No |
StartDate | Inception Date | Measure.InceptionDate | Inception Date | |||
Period | Initial Part Year (Hidden if a Full Year) | Initial Part Year (Hidden if a Full Year) | IPY.Hide | Initial Part Year (Hidden if a Full Year) | No | No |
EndDate | Latest | Latest | Latest | |||
EndDate | Latest -1 Open Day | Latest-1D | Latest -1 Open Day | |||
EndDate | Latest -2 Open Days | Latest-2D | Latest -2 Open Days | |||
EndDate | Latest -3 Open Days | Latest-3D | Latest -3 Open Days | |||
Period | Month to Date | Month to Date | MTD | Month to Date | Yes | No |
StartDate | Month to Date | MTD | Month to Date | |||
Period | Open Days | OpenDays | Open Days | No | Yes | |
Period | Performance History Start to End | Performance History Start to End | PerformanceHistoryPeriod | From the start to the end of the performance history | Yes | No |
Period | Previous Calendar Month | Previous Calendar Month | CM-1 | The previous calendar month, to be followed by Month to Date. | Yes | No |
Period | Previous Calendar Month but one | Previous Calendar Month but one | CM-2 | Previous Calendar Month but one | Yes | No |
Period | Previous Calendar Month but two | Previous Calendar Month but two | CM-3 | Previous Calendar Month but two | Yes | No |
Period | Previous Calendar Month to Date | Previous Calendar Month to Date | 2MTD | Previous Calendar Month to Date | Yes | No |
Period | Previous Calendar Quarter | Previous Calendar Quarter | CQ-1 | The previous calendar quarter, to be followed by Quarter to Date. | Yes | No |
Period | Previous Calendar Quarter but one | Previous Calendar Quarter but one | CQ-2 | Previous Calendar Quarter but one | Yes | No |
Period | Previous Calendar Quarter but two | Previous Calendar Quarter but two | CQ-3 | Previous Calendar Quarter but two | Yes | No |
Period | Previous Calendar Quarter to Date | Previous Calendar Quarter to Date | 2QTD | Previous Calendar Quarter to Date | Yes | No |
Period | Previous Calendar Week | Previous Calendar Week | CW-1 | The previous calendar week, to be followed by Week to Date. | Yes | No |
Period | Previous Calendar Week but one | Previous Calendar Week but one | CW-2 | Previous Calendar Week but one | Yes | No |
Period | Previous Calendar Week but two | Previous Calendar Week but two | CW-3 | Previous Calendar Week but two | Yes | No |
Period | Previous Calendar Week to Date | Previous Calendar Week to Date | 2WTD | Previous Calendar Week to Date | Yes | No |
Period | Previous Calendar Year | Previous Calendar Year | CY-1 | The previous calendar year, to be followed by Year to Date. | Yes | No |
Period | Previous Calendar Year but one | Previous Calendar Year but one | CY-2 | Previous Calendar Year but one | Yes | No |
Period | Previous Calendar Year but two | Previous Calendar Year but two | CY-3 | Previous Calendar Year but two | Yes | No |
Period | Previous Calendar Year to Date | Previous Calendar Year to Date | 2YTD | Previous Calendar Year to Date | Yes | No |
Period | Previous Day | Previous Day | D-1 | The previous day, to be followed by '1 Day' | Yes | No |
Period | Previous Day but 2 | Previous Day but 2 | D-3 | Previous Day but 2 | Yes | No |
Period | Previous Day but one | Previous Day but one | D-2 | Previous Day but one | Yes | No |
Period | Previous Fiscal Year | Previous Fiscal Year | Fiscal.CY-1 | The previous calendar year, to be followed by Year to Date. | Yes | No |
Period | Previous Fiscal Year but one | Previous Fiscal Year but one | Fiscal.CY-2 | Previous Fiscal Year but one | Yes | No |
Period | Previous Fiscal Year but two | Previous Fiscal Year but two | Fiscal.CY-3 | Previous Fiscal Year but two | Yes | No |
Period | Previous Month | Previous Month | M-1 | The previous month, to be followed by '1 Month' | Yes | No |
Period | Previous Month but 2 | Previous Month but 2 | M-3 | Previous Month but 2 | Yes | No |
Period | Previous Month but one | Previous Month but one | M-2 | Previous Month but one | Yes | No |
Period | Previous Quarter | Previous Quarter | Q-1 | The previous quarter, to be followed by '3 Months'. | Yes | No |
Period | Previous Quarter but 2 | Previous Quarter but 2 | Q-3 | Previous Quarter but 2 | Yes | No |
Period | Previous Quarter but one | Previous Quarter but one | Q-2 | Previous Quarter but one | Yes | No |
Period | Previous Week | Previous Week | W-1 | The previous week, to be followed by '1 Week' | Yes | No |
Period | Previous Week but 2 | Previous Week but 2 | W-3 | Previous Week but 2 | Yes | No |
Period | Previous Week but one | Previous Week but one | W-2 | Previous Week but one | Yes | No |
Period | Previous Year | Previous Year | Y-1 | The previous year, to be followed by '1 Year'. | Yes | No |
Period | Previous Year but 2 | Previous Year but 2 | Y-3 | Previous Year but 2 | Yes | No |
Period | Previous Year but one | Previous Year but one | Y-2 | The year previous to 'Previous Year' | Yes | No |
StartDate | Public Opening Date | Measure.PublicOpeningDate | Public Opening Date | |||
Period | Quarter to Date | Quarter to Date | QTD | Quarter to Date | Yes | No |
StartDate | Quarter to Date | QTD | Quarter to Date | |||
Period | To end of latest Fiscal Year | To end of latest Fiscal Year | Fiscal.ToEndOfLastYear | Can be used set set the anchor end date for a report that is produced on a yearly basis. | Yes | No |
EndDate | To end of latest Fiscal Year | Fiscal.ToEndOfLastYear | To end of latest Fiscal Year | |||
Period | To end of latest Month | To end of latest Month | ToEndOfLastMonth | Can be used set set the anchor end date for a portfolio that is reported on a monthly basis. | Yes | No |
EndDate | To end of latest Month | ToEndOfLastMonth | To end of latest Month | |||
Period | To end of latest Quarter | To end of latest Quarter | ToEndOfLastQuarter | Can be used set set the anchor end date for a report that is produced on a quarterly basis. | Yes | No |
EndDate | To end of latest Quarter | ToEndOfLastQuarter | To end of latest Quarter | |||
Period | To end of latest Week | To end of latest Week | ToEndOfLastWeek | Can be used set set the anchor end date for a portfolio that is reported on a weekly basis. | Yes | No |
EndDate | To end of latest Week | ToEndOfLastWeek | To end of latest Week | |||
Period | To end of latest Year | To end of latest Year | ToEndOfLastYear | Can be used set set the anchor end date for a report that is produced on a yearly basis. | Yes | No |
EndDate | To end of latest Year | ToEndOfLastYear | To end of latest Year | |||
Period | Week to Date | Week to Date | WTD | Week to Date | Yes | No |
StartDate | Week to Date | WTD | Week to Date | |||
Period | Year to Date | Year to Date | YTD | Year to Date | Yes | No |
StartDate | Year to Date | YTD | Year to Date | |||
Period | Year to Date (Hidden if a full Year) | Year to Date (Hidden if a full Year) | YTD.Hide | Year to Date (Hidden if a full Year) | No | No |