Limit number of years/quarters/months visible in a filter

1

Min/Max years in space properties

As a Space Admin, you can set a minimum year and a maximum year for filters that use the built-in Time attributes and time series measures in the space.

The default values are -1 and -1, translating into a default span of 150 years from 1900 to 2050.

• Go to Space Management, then Space Properties and the Advanced Tab
• You will find the Min/Max Years about halfway down the page
• Change the Settings. They will be automatically saved.

2

Editing the dashboard filter

If you have the Edit Dashboard right, you can create filters for the dashboard. For Time categories, you can use the following types of filters:

• Checkbox
• Radio button
• Slider
• Calendar

Checkbox and radio button filters are populated either with a query or a custom list.

You can edit the query to include only the time categories required for the dashboard. This can also be made to work dynamically using variables like {Current Year} defined in Space Management/Manage Variables.

Current Year Variable in Admin

An example on how to edit the Filter query can be found here:

If you want to include categories like Current Year and Prior Year in the filter then the Custom list is an awesome option. You have to list all the categories you want to have in the filter, and the values in the Value column have to be found in the data in your space/model.

Custom categories in a Checkbox filter

The Slider filter lets you choose the upper and lower limits in Custom Range. You can also limit the categories available with the Query.

Slider filter with Custom range of years.

The Calendar filter type lets you set default values including start and end values using Variables.

Calendar type filter, using the ‘between’ operator.

Variables as the default start and end values