In this article, I cover how to find your:
- Top sales day ever
- Top sales day each month
(1) Identify your top sales date ever
- Head to the table containing your sales data.
- Count your sales by day.
- Click the header of the count column.
- Click sort.
- In the sort modal, choose the descending option.
Done! The top result in the table is the one you're after.
(2) Identify your top sales day in each month
This one's a little trickier, but certainly possible 🤓
- Complete steps 1 and 2 of the method above.
- Click the header of the column containing the transaction date.
- Select more options.
- In the format as section, choose year-month.
- In the modal that appears, click done. A new column containing the month will be added.
- Click the plus icon above the table.
- Select calculate as new column.
- In the choose calculation section, select max(the-date-column) (where the-date-column is the column in your table containing the transaction date (tip: it's often called created_at)).
- In the group results by section, select the new month column you created in step 5.
- Click done. A new column containing the max number of sales in each month will be added.
- Click the filter button above the table.
- Select your count column and then choose the equals operator.
- Click the show other columns link.
- Select the column you created in step 10 that contains the max per month.
- Click the plus icon above the table.
- Select hide columns.
- Hide the two custom columns you created (i.e. the month column and the max column).
All done! 🚀
You now have a table containing each month's top sales day 😀
---------
Have a question?
We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor.io.