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