Is it possible to have hourly Column Headings versus whole times or days or months in a crosstab query.
What I need to find out is how many people are logging in between 12-1 between 1-2 and so on. So I was picturing something like this:
..................8.....9.....10.....11.....12
url1..............4.....1.....10.....20.....0
url2..............1.....2.....15.....23.....18
url2..............8.....5.....13.....17.....25
Where the numbers at the top are the hours and the urls are the row headings and the # of clicks or hits or whatever show up under the hours.
I know how to set up a crosstab query and I know how to make it count my clicks etc. I just don't know how to make the hours the headings ... or if it's even possible. When I search for hourly or hour in the help I come up with nothing.
Thanks so much for any help you can give.
What I need to find out is how many people are logging in between 12-1 between 1-2 and so on. So I was picturing something like this:
..................8.....9.....10.....11.....12
url1..............4.....1.....10.....20.....0
url2..............1.....2.....15.....23.....18
url2..............8.....5.....13.....17.....25
Where the numbers at the top are the hours and the urls are the row headings and the # of clicks or hits or whatever show up under the hours.
I know how to set up a crosstab query and I know how to make it count my clicks etc. I just don't know how to make the hours the headings ... or if it's even possible. When I search for hourly or hour in the help I come up with nothing.
Thanks so much for any help you can give.
