Help

Average of sales per day of the week

Solved
Jump to Solution
696 1
cancel
Showing results for 
Search instead for 
Did you mean: 
CrushTeam
4 - Data Explorer
4 - Data Explorer

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 ! 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

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