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.

To run a query from the Analytics tab:

  1. On the Analytics tab, click Select Queries

    The Queries dialog opens and lists the queries 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 selected queries display on the Analytics tab in the Queries pane.

  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. You can edit one or both of these dates.

    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 Report Comment, enter a description.

  5. Click Get Data

    If the query returns data, then the results display on the Analytics tab in the Results pane .

  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 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.

      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.

    • 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.