Question

chart date granularity for week not following any standard


ERG!!! This is not following any standard for week numbers.



Here I was attempting to make everything work with the data grouped by week that starts on a Monday or Sunday. Nope. First day for the year this year, 2015, is Thursday. So the first day of week for every week is Thursday.

3 replies

Badge +6

Yep, it’s weird, but it was intentional to be consistent with the way Salesforce calculates “Week in Year” in SOQL:

“1 for January 3 The first week is from January 1 through January 7.”

Try running the following query, and I think you’ll see what I mean:

SELECT CreatedDate FROM skuid__Page__c WHERE WEEK_IN_YEAR(CreatedDate) = 1

Badge +20

Well. If someone jumps off a bridge …

There should at least be a note on this in the Chart component when Week is chosen.

Badge +4

You’re right, Pat. This needs to noted, so I added it to the tutorial. I’m guessing you think it should be a tooltip on the Default Date Granularityso that you can find this information without wandering over to the documentation. I’ll make that suggestion.

Reply