I just came across an odd situation. I was loading some data into MDA (creating zeros so the time series charts look right) and selected "first day of last week" as the date value.
When I checked the file, the "first day of last week" according to the rules engine was 2/27/16, which is right because my Time Granularity under Usage Configuration is set so the week starts on Saturday. (Why Saturday? No idea... That's just what we did back when! :-)
But when I group the data by week in the MDA report I get the week starting on 2/29/16.
It's easy enough to fix in this use case, but it could through some people off so I thought it'd be worth highlighting.
Solved
The week starts on different days between Usage/Rules Engine and MDA
Best answer by Sanchita
Hi
I understand but few of the customers prefer to have the start of the week set to Sunday’s or anything else. Therefore we cannot have this set for all customers. We give an option to edit it here at the Application settings to best benefit based on which day you’d like to set your start of the week.
+2Thanks for the heads up Jeff, I will look into this issue.
+1+1
Given ISO 8601 which considers Monday the first day of the week, can GS establish a consistent use of this standard?
This is creating significant pain points in basic reporting expectations where the report can look wrong but the data is correct, I am concerned many customers are not aware of this unexpected difference.
First day of the week in reporting
First day of the week in rules
First day of the week in data designers
Could these please be updated maintain the same standard?
Hi
I understand but few of the customers prefer to have the start of the week set to Sunday’s or anything else. Therefore we cannot have this set for all customers. We give an option to edit it here at the Application settings to best benefit based on which day you’d like to set your start of the week.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.