Project Online: cannot group by "week of year"

%3CLINGO-SUB%20id%3D%22lingo-sub-1712945%22%20slang%3D%22en-US%22%3EProject%20Online%3A%20cannot%20group%20by%20%22week%20of%20year%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1712945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EDoes%20anybody%20know%20how%20to%20Group%20by%3A%20week%20of%20year%20in%20Project%20Online%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20group%20by%20date%20and%20then%20choose%20Units%2Fdate%20format%20%22January%202010%22%20to%20group%20by%20month.%20However%20in%20date%20format%20drop%20down%20list%20there%20is%20no%20option%20for%20%22week%20of%20year%22.%3C%2FP%3E%3CP%3EIn%20Desktop%20App%20this%20is%20achived%20in%20Group%20Definition%2F%20Define%20Intervals.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1712945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Does anybody know how to Group by: week of year in Project Online?

I group by date and then choose Units/date format "January 2010" to group by month. However in date format drop down list there is no option for "week of year".

In Desktop App this is achived in Group Definition/ Define Intervals.

Thank you.

 

 

1 Reply
Highlighted

@Ignanikola I shall manipulate the date by using REST/CSOM then convert the date into WEEKNUM then post back to Project Online to another custom field (for example "Week Number" as integer).