ÃÛ¶¹ÊÓƵ

Date ranges overview

In a Workspace project, you typically use the calendar in a panel to specify the date range for the visualizations in that panel.

Date range components enable you to define and override the calendar settings for the panel.

Use date ranges

You can use a date range component to redefine the calendar for the panel.

Or, you can use a date range in a Freeform table as a metric or dimension.

Date range usage

  • Metric. For example, to compare a dimension for two different months for a specific metric.
  • Dimension. To compare a metric on different dimension items for the date range dimension.
NOTE
When you use date ranges in a Freeform table, the date ranges override the calendar specified for the panel to which the Freeform table belongs.

You use a date range as you would use any component. You drag the date range from the Calendar Date ranges component panel and drop the component on:

  • Calendar: You Switch Replace the current calendar configuration with the date range.
  • Metric column header: You Switch Replace the metric, Add Add the date range as a metric, or Filter Filter the metric using the date range component.
  • Dimension column header: You Switch Replace the current dimensions. The new dimension is now Date ranges. Once the dimension is Date ranges, you can Add Add additional date ranges as dimension items.
  • Dimension item: You Breakdown Breakdown the specific dimension item by the date range.

You can also add a date range column directly in a Freeform table visualization:

  1. In a metric column, select from the context menu:

    • Add time period column. You can select between suggested options that are based on the current calendar or create a custom date range.
    • Compare time periods. You can select between a suggested option that is based on the current calendar or create a custom date range.
  2. Based upon your selection, additional date range columns are added to the Freeform table.

Default date ranges

Analysis Workspace provides a number of default date ranges.

Day
Week
Month
Quarter
Year
Today
This week
This month
This quarter
This year
Yesterday
This week (excluding today)
This month (excluding today)
This quarter (excluding today)
This year (excluding today)
2 days ago
2 weeks ago
2 months ago
3 days ago
3 weeks ago
3 months ago
Last 7 days
Last week
Last month
Last quarter
Last year
Last 14 days
Last 2 full weeks
Last 2 full months
Last 4 full quarters
Last 30 days
Last 3 full weeks
Last 3 full months
Last 60 days
Last 4 full weeks
Last 6 full months
Last 90 days
Last 12 full weeks
Last 12 full months
Last 7 full days
Last 52 full weeks
Last 13 full months
Last 14 full days
Last 30 full days
Last 90 full days

Custom date ranges

You can create your own custom date ranges. See Create date range for the various options available to create date ranges. You then build, modify, and save date ranges in the Date range builder.

You use the Date range manager to manage date ranges.

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79