Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Report by Customer Day...

Report by Customer Day of the Week Purchases

(0) Share

Report

Posted on by Community Member

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

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Report by Customer Day of the Week Purchases

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.