In Arcadia Enterprise, the relative date mode in a date filter enables you to select a subset range of dates anchored to a particular date.
This article describes how to use relative date mode in a calendar heat map visual.
In the following example, we demonstrate how to anchor a date to 2015-01-01 and limit the visual output to next two years from this date.
The following steps use a calendar heat map visual, which is built on the dataset Food
Stores Inspection in NYC
.
In the visuals menu, find and click Calendar Heatmap. Make sure
you select the Food Stores Inspection in NYC
.dataset.
inspection_date
, and drag and
drop it to the Date shelf of the visual.Record Count
, and drag and
drop it to the Measures shelf of the visual.Note that the calendar heatmap visual appears in the main area of the interface with inspection dates for three years: 2015, 2016, and 2017.
At the top left corner of the Visual Designer, click Save.
Under the Dimensions category, click the
inspection_date
field.
inspection_date
, and
has a type timestamp
.Note that the dashboard filter contains the date range for the entire dataset; in this case, it is for three years from 20015-01-01 through 2017-12-31.
On the filter, click the (calendar) icon, and select the Relative Dates option from the menu.
The other options are Days, Weeks, Months, Quarters.
The other options are Previous Year, This Year, Next Year, Custom, Last <number>Years, Year to date.
Note that the visual output is now limited to two years, starting from the anchor year of 2015, and that the application filter shows the new date range of 2015-01-01 - 2016-12-31.