Expand my Community achievements bar.

Group By Week - Not on a sunday

Avatar

Level 2

Is it possible when grouping a list of tasks by week to control the day that the week begins on? I don't like that it's defaulting to Sunday and want to customize it. 

4 Replies

Avatar

Level 3

Do you want to shift the definition of the week or just the displayed date on the grouping?

 

For the latter, you can use a valueexpression in the grouping to ADDDAYS(YourDate, 1) to show Monday instead of Sunday.

Avatar

Level 2

Thank you! I'm not the best with text mode beyond some basics. 

 

If this is my grouping in text mode, what would I change to produce that result? Ideally, I want to show every friday instead of Sunday because that aligns better with our commission cycle. 

 

textmode=true
group.0.linkedname=direct
group.0.namekey=Commissionable Date
group.0.valuefield=Commissionable Date
group.0.notime=true
group.0.groupdatesby=WY
group.0.valueformat=customDateAsWeekString

Avatar

Community Advisor

Would it work when shown in a chart too or would that only reflect in a report's detail view? Also wondering how exactly would enter in text mode if you have an example snippet!

Avatar

Level 2

I'm not sure what the text mode is exactly, that is what I was hoping to find out from someone in the community.