You’re offline. This is a read only version of the page.
Hello,
I am interested in creating a report from our sales data that will show me which customers come regularly on certain days of the week. For example, many of our customers will come to our store and purchase items every Monday or every other Wednesday. Is there any way that I can run a report that will show me the customer ID along with what day of the week they come regularly? I see where I can run a report and select a range of dates, but I don't see where I can select individual days of the week. Any suggestions would be greatly appreciated!
Thank you!
*This post is locked for comments
I have the same question (0)
Add this column to your Detail Sales Report. Also say your report as "Custom - Detailed Sales Report.qrp" so that updates don't overwrite your changes.
Begin Column
FieldName = "[Transaction].Time"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Day of Week"
VBDataType = vbString
Formula = "DATENAME(weekday, [Transaction].Time)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1500
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Then you can set your filter so that only customer sales show on the report. You can also set for sale date range.
Customer <> 0
Then you can drag "Day of Week" to the first column and group.
Share
Report
All responses (
Answers (
