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

jj1

New member
Local time
Today, 00:49
Joined
Jan 28, 2015
Messages
3
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
 
Create a query that pulls up the top 5 problems, the week, and whatever other data you need. Then sort by problem in descending order and week in ascending order.
 
No I understand that but what I am looking for is once I know my top 5 issues. Spilt my each issue on week by week basis in one chart

so charts should look like below in a report



Count:3 4 5 5 4 5 6 6
Week1, Week2, Week3, Week4 Week1 Week 2 Week3 Week4
Problem1 Problem 2
 
Ok, assuming your Week data is all saved in one field, then what you're looking for is a crosstab query.

I think.

It would help if you could post a mock-up of what you want the end result to look like.
 

Users who are viewing this thread

Back
Top Bottom