How to write an OData query in order to get Months (or weeks ) on an horizontal timeline

%3CLINGO-SUB%20id%3D%22lingo-sub-2299651%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20an%20OData%20query%20in%20order%20to%20get%20Months%20(or%20weeks%20)%20on%20an%20horizontal%20timeline%20and%20th%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299651%22%20slang%3D%22en-US%22%3ESorry%2C%20I%20added%20a%20JPG%20file%20a%20lot%20too%20big%20%3A(%3C%2Fimg%3E%20I%20don't%20know%20how%20to%20delete%20it%20%3A(%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299619%22%20slang%3D%22en-US%22%3EHow%20to%20write%20an%20OData%20query%20in%20order%20to%20get%20Months%20(or%20weeks%20)%20on%20an%20horizontal%20timeline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299619%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EHow%20to%20write%2C%20in%20Excel%2C%26nbsp%3B%20an%20%3CSTRONG%3EOData%3C%2FSTRONG%3E%20query%20in%20order%20to%20get%20%3CSTRONG%3EProject%20Online%3C%2FSTRONG%3E%20data%20with%26nbsp%3B%3CSTRONG%3EMonths%3C%2FSTRONG%3E%20(or%20weeks%20)%20on%20an%20horizontal%20timeline%20and%20the%20resources%20names%20as%20row%20headers.%20For%20example%20in%20an%20Excel%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

How to write, in Excel,  an OData query in order to get Project Online data with Months (or weeks ) on an horizontal timeline and the resources names as row headers. For example in an Excel pivot table.

 

Thanks for your help

 

1 Reply
Sorry, I added a JPG file a lot too big :( I don't know how to delete it :(