• Replies 4 replies
  • Subscribers 701 subscribers
  • Views 217 views
  • Users 0 members are here
Options
Related

Week Filters

Tom Brown (Past Member)
$organization

Has anyone worked out how to adjust the start of the week for week filters in Tessitura Analytics?  Right now my system seems to be using a Monday to Sunday week.  My organizations prefer a Saturday to Friday Week.  Can this be adjusted?

Parents
  • $organization

    Hi Tom,

    The following fields in and collection of date fields (eg. CAMPAIGN START DATE) are determining their day of week start from the T_DEFAULTS setting for EIS FIRST DAY OF WEEK.

    • Calendar Week of Month
    • Calendar Week of Year
    • Day of Week
    • Day of Week Sort
    • Fiscal Week of Year

    However, the native Sisense date field, called "Date" within each collection of date fields, does use the server setting for its week related filters and functions, and you are correct that in a shared Analytics instance, we cannot set it differently for different organizations on the shared instance. Therefore we may have to turn to formulas for some use cases that would be somewhat easier were we able to impact that instance-level setting.

    Best,
    Chris

Reply
  • $organization

    Hi Tom,

    The following fields in and collection of date fields (eg. CAMPAIGN START DATE) are determining their day of week start from the T_DEFAULTS setting for EIS FIRST DAY OF WEEK.

    • Calendar Week of Month
    • Calendar Week of Year
    • Day of Week
    • Day of Week Sort
    • Fiscal Week of Year

    However, the native Sisense date field, called "Date" within each collection of date fields, does use the server setting for its week related filters and functions, and you are correct that in a shared Analytics instance, we cannot set it differently for different organizations on the shared instance. Therefore we may have to turn to formulas for some use cases that would be somewhat easier were we able to impact that instance-level setting.

    Best,
    Chris

Children