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?
I assumed that is was using SELECT DATEPART(dw,GETDATE()) Then again our @@DATEFIRST is 7 (Sunday) and our day of week in analytics is Monday as 1 so that rules that out
Looks like it's an admin setting https://documentation.sisense.com/7-1/administration/system-settings/system-configuration.htm#gsc.tab=0
Thanks, Heath Wilder
As RAMP users we can not adjust that in Admin ourselves. So maybe I need to place a Support Ticket?
I suspect that then the question is will the network adjust this, as we are on a shared instance. I'm not clear if this adjustment affects just a single eCube or multiple on a single instance. If this becomes a challenge for us internally, and we have a consensus internally about the importance of this I'll reach out.
There are other things I'd prefer the network staff focusing on right now.
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.
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
Chris Wallingford thanks for the insights.
What is Tessitura Networks standard setup for the week setting on instances? I'm seeing Monday to Sunday weeks is that the standard?