What week of the year is the busiest?

(Last updated on: May 11, 2017)

Want to drill deep to see a week by week comparison of sales totals? You can do it easily by modifying the query in the Export email function.

Go to Mailing list | Generate a mailing list | Export email, then click on the Edit the query tab. Copy and paste the codes below, then click Export list.

select weekofyear(today_date) as Month, sum(total_tix) as Tix, sum(total_sale) as Sales from mainsale group by weekofyear(today_date);

Here is a sample of the report:


This entry was posted in Desktop Software, Reports, Wintix5 and tagged . Bookmark the permalink.

Leave a Reply