The new functionality 'Analyze', that can be accessed through different pages, offers the possibility to filter Posting Date Per Year, Quarter and Month. I am missing the possibility to filter per Week. This would be a great addition.
Comments
Currently we are working around this by adding dedicated calculated fields to tables via AL extensions that calculate the start of the week for a given date field, and then we use that to pivot on in Analysis View. The main issues with this approach is that it requires AL development for each date we want to pivot on, and if you drag the new date into the Rows section it gets treated as Text when sorting rather than a Date.Native support for Per Week analysis for all Dates would be great.
Category: Project Management
Please consider this great idea.
Category: Project Management
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team