Defining a time hierarchy from a time-series column

Time data is by nature structured hierarchically. When specifying a column with dates or times in a column selector, you have the option to change the default linear series of dates to a hierarchical view of dates in the form of years, quarters, months, weeks, days, and so on.

About this task

When you are working with time-series data (Date, Time, DateTime or TimeSpan columns), you can set up a hierarchical structure directly from the column selector.

Procedure

In the column selector, click the arrow next to the column name. A popover listing all columns opens. Time-series columns have arrows indicating they can be expanded.
Click the time-series column of your choice to expand a list of display options. The options highlighted in the image offer different time hierarchies, but you can also select a specific date or time part.
Select the desired date/time part or hierarchy.

Results

If a hierarchy was selected, the selected column is shown on the axis with a slider where you can specify which date or time part to inspect by adjusting the slider.

Due to the natural hierarchical form of time-series data, you can also perform additional operations with time hierarchies, such as compensating for missing values.