Average of sales per day of the week

[CrushTeam]

Hello ! 

I document the sales of my stores everyday on Airtable - each sale is entered with its date of transaction.

I would like to get the sales average per day of the week (i.e know on which days we sell the most on average), ideally with a graph with the X axis being the days of the week. Is it possible ?

Thank you ! 

[TheTimeSavingCo · Accepted solution]

Yeap this is possible.  Try this:
1. Create a formula field that'll output the day of the week of the sale
2. Create a new table called "Days of the week" or something
3. Link "Days of the week" to the table that contains all your sales information
4. Click the header of the formula field from step 1 to select the entire column, and then copy the values
5. Click the header of the linked field and paste the values in, this should link everything up
6. In the "Days of the week" table, create a rollup field with the formula `SUM(values)`

This should give you a table that has 7 records, each representing a day of the week, as well as how much in sales you did on each day.  You can now use this in a chart and make the X axis the days of the week like you said