Skip to main content
Nintex Community Menu Bar
Question

chart date granularity for week not following any standard

  • July 9, 2024
  • 3 replies
  • 26 views

Forum|alt.badge.img+20

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

Forum|alt.badge.img+6
  • Nintex Employee
  • July 9, 2024

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


Forum|alt.badge.img+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.


Forum|alt.badge.img+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.