Query for top 5 issues each issue spilt week by week in one chart

[jj1]

I am trying to build a query where I can pull top 5 issues each issue spilt week by week. How can I write that query. So something like this

Problem A ------Week 1
_____Week 2
_____ Week 3
_____ Week 4
Problem B --------Week 1
______Week 2
_______Week3


_______Week 4

So rotten apple is my top issue by count I want see over month how my issue stayed week by week. In the same chart Problem A and Problem 2 spilt by 4 weeks

[June7]

This can get tricky.

Calculate a field in query to extract year, month, week number from the date value then use those in combination to organize records.

Year([Datefield]) & Format(Month([Datefield]), "00") & DatePart("w", [Datefield]) AS YrMoWk

but that will return the week numbers within each month which means first and last weeks can be less than 7 days and some months will have 5 week numbers.

DatePart("ww", [Datefield]) will return week numbers within the year (1 - 53), again first and last weeks can be less than 7 days.

However, seems this will meet you requirement for weekly count within month.