CHARTING DATA (CHARTS VISITS REPORT DETAILS)

AccuSQL/AccuTrack provides you with a powerful view of your center’s usage pattern via informative and colorful charts. AccuSQL/AccuTrack uses Microsoft Excel for creating 10 charts and 6 pivot tables that provide a wealth of information on how your center is used. This includes usage per hour, day, and week, usage per class, and the number of returns. To see these charts click on the “Chart Visits” button in the Reports screen. AccuSQL/AccuTrack will generate the needed data and start Excel automatically. It will then pass commands to Excel to create the pivot tables and graph the charts. When done, it will display an Excel Workbook with the charts and tables.

Important: Let the Chart Visits report finish completely in Excel before you close the Excel program, or AccuSQL/AccuTrack will display a warning message indicating it did not complete the report building process successfully.

Tip: You can view the different charts in Excel by simply clicking on the tabs at the bottom of the screen. To see all the tabs, click on the arrow buttons next to the tabs.

Tip: If you hold the mouse pointer on a segment of the chart for a few seconds, Excel will display the name and value of that segment:

The following pages describe the available charts and data.

This chart depicts the number of visits per week. On the vertical axis you will notice the week number. On the horizontal axis you will see the number of sign-ins. Each horizontal line represents one week, and is composed of several colored segments that represent the days of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value.

This chart depicts the number of visits by day of the week. The vertical axis shows the number of sign-ins, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the visits will be added for each day. Thus the chart represents the cumulative number of visits for each day.

Like the previous chart, this chart also depicts the number of visits by day of the week. However, each vertical bar is composed of segments representing the hours of the day. You can see which hours the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents. Note that this chart also represents the cumulative number of visits for each day and period of the day.

This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

The number of visits shown in this chart is cumulative for each hourly period.

This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. This chart shows a summary of guest sign-ins in addition to student sign-ins, unlike the ‘Number of Sign-Ins by Hour’ chart, which merely shows student sign-ins.

The number of visits shown in this chart is cumulative for each hourly period.

This table shows the number of sign-ins for each week of the year split by week of the day. The rows are summed up to show the total number of sign-ins per week, and the columns are summed up to show the total number of sign-ins per day for all the weeks.

This table shows the number of sign-ins for each period of the day distributed per day of the week. The rows are summed up to show the total number of sign-ins per period, and the columns are summed up to show the total number of sign-ins per day for all the periods.

This table shows the number of visitors for each period of the day distributed per day of the week. The rows are summed up to show the total number of visitors per period, and the columns are summed up to show the total number of visitors per day for all the periods. This chart is similar to the ‘Number of Sign-Ins’ table, except that it shows the guest sign-ins in addition to student sign-ins. This enables you to determine what the peak hours are for visitors during each day individually or throughout the week as a whole.

This chart depicts the length of the sign-in visit for each week of the year. On the vertical axis you will notice the week number, and on the horizontal axis you will see the total session times in hours. Each horizontal line represents one week, and is composed of several colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value.

This chart depicts the length of visits by day of the week. The vertical axis shows the length of sign-in sessions, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the length of visits will be added for each day. Thus the chart represents the cumulative session length for each day.

This chart depicts length of the session for students signing in during that hour. The vertical axis shows the length of visits in hours, while the horizontal axis shows the hourly periods of the day. Each vertical bar shows the total length of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

The number of visits shown in this chart is cumulative for each hourly period.

This table shows the length of sign-in periods for each week of the year split by week day. The rows are summed up to show the total hours of sign-ins per week, and the columns are summed up to show the total hours of sign-ins per day for all the weeks.

This table shows the length of sign-in periods for visitors signing in during each hour of the day distributed by the days of the week. The rows are summed up to show the total hours of sign-ins periods per hour, and the columns are summed up to show the total sign-in hours per day for all the hourly periods.

This chart shows the number of sign-ins per activity (class/service). The activities are grouped by their categories. The vertical axis shows the number of visits, while the horizontal axis shows the category of activities (subject area…). Each vertical bar shows the number of visits per activity. You can see which activity the bar represents by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

This table shows the number of sign-ins for each activity (class /service) during the reporting period.

This chart shows the number of repeat visits for your visitors. The vertical axis shows the number of students returning, while the horizontal axis shows the number of times these students returned. Each vertical bar shows the number of students that returned that many times.

This table shows the returning visits distribution during the reporting period. Each row shows the number of visits in the first column and the number of students who visited that many times in the second column.

Previous - SUCCESS PLAN REPORTS | Back to TABLE OF CONTENTS | Next - EXPORTING REPORT DATA