Skip to main content
EMS Software, LLC

Analytics Tab

The Analytics tab provides quick access for queries that have been defined using the Query builder and to which you have access as a user. You can run these queries from the Analytics tab.

emsum_Dashboard_image015.png

To run a query from the Analytics tab

1. In the upper left corner of the Analytics tab, click Select Queries. The Queries dialog box opens. This dialog box lists the queries that have been defined using the Query builder and to which you have access.

2. Select the queries that you want to run, and then click OK. The Queries dialog box closes. The selected queries are displayed in the Queries pane (upper left) on the Analytics tab.

3. In the Queries pane, select the query that you want to run, and then select the date for which the data in your EMS database is to be queried.

Option

Description

Custom

The starting date is set to the first day of the month and the ending date is set to the last day of the month but you can edit one or both of these dates.

Note: For some queries, if you select Custom, a Use Specific Times option becomes available. If you enter the same date for the starting date and ending date, you can select Use Specific Times, and then enter a starting time and ending time to query the data for in specific time range on the same day.

Last Month

The starting date is set to the first day of the previous month and the ending date is set to the last day of the previous month.

Last Quarter

This Quarter

This Quarter To Date

Quarters are based on a calendar year:

• First quarter is 1/1 through 3/31.

• Second quarter is 4/1 through 6/30.

• Third quarter is 7/1 through 9/30.

• Fourth quarter is 10/1 through 12/31.

For example, if the current day’s date is 11/22/2010, and you select Last Quarter, then the starting date is set to 7/1/2010 and the ending date is set to 9/30/2010.

Last Year

The starting date is set to 1/1 of the previous year, and the ending date is set to 12/31 of the previous year.

This month

The starting date is set to the first day of the current month and the ending date is set to the last day of the current month.

This Year

The starting date is set to 1/1 of the current year, and the ending date is set to 12/31 of the current year.

This Year to Date

The starting date is set to 1/1 of the current year, and the ending date is set to the current day’s date.

4. Optionally, in the Report Comment field, enter a description or explanation of the query.

5. Click Get Data. If the query returns data, then the results are displayed in the Results pane on the Analytics tab.

6. Optionally, do one or more of the following:

• To export the query results to an Excel spreadsheet or to an XML file, click Export, and then select the appropriate file type. A dialog box opens in which you can specify the file name (the default file name is the name of the query, but you can always edit this), and the location to which to save the file.

emsum_Dashboard_small_reminder.png

The file type for an Excel spreadsheet is .xl or .xls and you cannot change this. The file type for an XML file is .xml and you cannot change this.

• To generate an onscreen preview of the printed query results, click Print. The preview window contains options for printing a hard copy of the query results, for emailing the results, and so on. Select the option or options that best fit your working needs.

Onscreen preview of a query results

emsum_Dashboard_image016.png

• If the query has been defined with a Chart, the Chart option is enabled. Click Chart to generate an onscreen preview of the charted data. The preview window contains options for printing a hard copy of the chart, for emailing the chart, and so on. Select the option or options that best fit your working needs.

Onscreen preview of query results that are charted/graphed

emsum_Dashboard_image017.png