Spotfire: Changing Time Hierarchy using Multiple Date Columns

Posted on Updated on

When using multiple date columns (switched using property control) on a particular axis, we lose the ability to change the time dimension of the date selected. In order to overcome this issue, we can add a Time Hierarchy property control (a slider) and use it to alter the date column’s time hierarchy.

We start off by building a property control for changing date column. An important note here is to provide the Value as exact literals of the column name which you want to use against a Display Name. 

Change_Time_Hierarchy_3

Then we create a TimeHierarchy slider control to navigate across three dimensions – Year, Quarter and Month.

Change_Time_Hierarchy_4

And apply the below custom expression on the date column.

Change_Time_Hierarchy_5

This customization allows us to change the Time Hierarchy for Date columns. Below is a view of quarterly Sales (by Order Date)

Change_Time_Hierarchy_2

And a monthly Sales view (using Dispatch Date)

Change_Time_Hierarchy_1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s