JoshuaMcAfee
10 years agoQrew Member
field day of week formula
Hi I am trying to build a sales report/graph. I would like to visualize which day of the week gets the most sales. Within the sales table we have a field title Order Date, that we formatted to have the date and day of the week.
What I would like is a report/graph that would group all of the sales together by day of the week for example (all the sales of June grouped into Monday, Tuesday, Wed,etc) where Monday would have all 4 Mondays of the month combined, Tuesday the same etc. and then show the total so we know what days get the most sales combined.