Business day tables

Business days are customized sets of days that are important to an organization (for example, working days). With the appropriate setup and licensing, you can filter the view to only see data for these business days.

To filter out data for all other days

Select the business day table in day filter area of date settings.

Tips

You cannot turn on business day tables when viewing a data cube that has a time component.

You can hide the filtered dates completely or show the filtered dates with zero data values using the Hide Filtered Time Periods option.

Day counts and business days

If your dataset includes day counts or calculations based on day counts, consider the following when using business day tables. For clarification about the setup and meaning of measures in your dataset, contact your system administrator.

• Generic day counts using the $Days( ) function always represent the days in the current view. If no business day table is turned on as a filter, then it will count all the days in the selected date range, filtering out any days of the week excluded by a day filter. If a business day table is on, then it will further filter the days to include only those in the selected business day table.

• Calendar day counts using the $Days($Calendar) function always count the number of days in the selected date range, filtering out any days of the week excluded by Salient Dashboards’s day filter. This variable never takes business day tables into consideration.

• Day counts based on specific business day tables (for example, $Days(WorkingDays)) count the number of days in the business day table specified, also filtering out any days of the week excluded by a day filter. This variable always filters the days to include just those in the business day table specified in its definition, even if the business day table isn’t selected in Salient Dashboards.

• Measures included in a formula with a day count (for example, Sales Units in Sales Units/Day) always use the days in current view, and do take the currently selected business day table and day filters into consideration.