ContributionsMost RecentMost LikesSolutionsRe: field day of week formulaThanks where would I call the second part into. When I create the top part by its self it says "you used a text formula but the formula returns a number?Re: field day of week formulaSo where would I put these formulas as I am building it out. Sorry still a bit new to the platform.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.