Need help with Monthly Transaction By Hour Report

[Former Member]

Post Author: cbcombs

CA Forum: General

Hello,Newbie needs to write a transaction report that is grouped by days of the week for a calendar month. It will have one column for each day of the week and each of those columns will contain a whole months of week day data. Then it will be grouped by each hour of the day. It will contain the number of transactions for each hour. And then a weekly average of the number of transactions for each hour of the day. The week starts on a Monday and goes through Sunday. They are probably going to want the dollar amount of the transactions too. Below is an example with the first two rows of data populated. Monthly Transaction Report For August 2007 Mon Tue Wed Thu Fri Sat Sun Average08:00 0 2 2 1 10 5 2 3.1409:00 25 3 5 4 5 8 6 4.43 10:00 5011:00 10012:00 15013:00 15013:00 12514:00 10015:00 5016:00 1017:00 2 Any help would be appreciated.

[Former Member]

Post Author: kbrinton

CA Forum: General

you could write a formula but I have attached a link to a report I found that was really helpful when making a calendar. You may be able to use this to get the results you are looking for. http://www.ml-crystal.com/articles/calendar.htm

[Former Member]

Post Author: cbcombs

CA Forum: General

Hi, I did that, but I am getting a column (31 one of them) for every day of the month. What I need is one column for every day of the week, and then all of the month's data consolidated into it's respective day of the week column. So, seven columns only (Mon - Sun), plus one column for the average. Any ideas?

[Former Member]

Post Author: kbrinton

CA Forum: General

You could use the cross tab expert and set the columns to the day and the row to hours with it summing your transactions. So for the rows choose your date field and then choose Group options and have it set to "for each hour". Then the column choose your date field and have it set to "for each day". Then have it summarize your transactions.

Hope this helps!!