What month is the busiest?

Want to know which months are your busiest? Having this information can help your theatre plan shows and marketing efforts to increase sales during slower times.

Wintix will show you which are your busiest months.

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

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

Here is a sample of the report:

months

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

Leave a Reply