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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156