Chart Report

The Chart Report allows you to report and analyze data in a graphical format for more intuitive visual analysis. You can save a Chart Report as a favorite, schedule it to run, and then distribute it automatically via email, without end-user intervention.

When the output type is set to "Web page," you also can drill-down into the report results to obtain more granular information on a specific item by simply clicking on that item. You can then navigate between different result sets to allow you to do easy comparisons.

To access the Chart Report:

  • From the Application Function Bar, select Reports  Reports Admin Case Reports  Chart Report.

Report Options

The following options are available for this report.

Field Description

View As

Select the output type of the report. For a Chart Report, select from the following:

  • Web page - This is the default option. The report results will appear directly in your browser, in the Results view of the report window. This option will create an HTML file which can be added to an internet or intranet site.
  • XML - The report will be output in its raw XML format, which is the data format returned by the Emplifi Agent Server.
  • One of the following image formats:
    • PNG
    • JPEG
    • GIF
    • BMP

 

Chart Category

The chart category is the primary category for the report. You have the option of choosing a date-type category, or a standard data category.

If you select a date-type category as the chart category, the chart will be presented as a trend graph. You are also required to fill out the time frame information.

If you select a standard data category as both the chart category and chart series, the chart will be presented as a crosstab graph.

Field Description

Category

Select a primary category for the report.

Level

If the selected category is a code hierarchy, select the level within the hierarchy on which you want to report.

Display

Select how you would like information from a code hierarchy to be displayed. You can select from either the code or one of the three descriptions, or a combination of code and description 1.

Top-N Limit

If you would like to limit the chart to include only the most frequently occurring codes, you can enter the number here (for example, show the top 5 issue reason codes or show the top 10 products with the most issues).

Report Time Frame

This is the time frame in which data will appear on the report.

 

Chart Series

Field Description

Category

Select a secondary category for the report.

Level

If the selected category is a code hierarchy, select the level within the hierarchy on which you want to report.

Display

Select how you would like information from a code hierarchy to be displayed. You can select from either the code or one of the three descriptions, or a combination of code and description 1.

Top-N Limit

If you would like to limit the chart to include only the most frequently occurring codes, you can enter the number here (for example, show the top 5 issue reason codes or show the top 10 products with the most issues).

Normalization Set

Select the name of the appropriate normalization set by which to normalize your report results.

Normalized reporting can provide a more accurate evaluation of your data by considering factors such as the number of units sold, the total value of items sold, or the number of customers served. For a full explanation on how normalized reporting works, refer to Normalized Reporting Overview.

Note: Rows with Norm Set Data of "0.0" or that are missing Norm Set Data are not included in the totals for the reports.

Also, when different categories have the same code or folder value, the correct normalized values are reported. In addition, when a category is the same as another Company ID (not the Company ID of the reporting data), the normalized values are taken from the “same as” Company ID for the category and the frequency counts are taken from the company for which the report is being run.

Normalization sets can be entered manually (refer to Normalization Set Maintenance) or imported using the Normalization Data Import Utility.

Scale Factor The scale factor is filled in directly from the information contained in the Normalization Data Set. (for a definition of scale factor, refer to Normalization Data Set.) You can override the value here if you want.
Period Offset

This setting allows you to normalize the data from a period against the normalization data from a previous period. The default value of zero will use the data from the current period. Enter a negative number to run the normalization using a previous period.

ClosedExample

Today is July 1, which is in the fiscal month "July05."  You are running a report with a report time frame of Fiscal Month, with a range of "p-13" through "p-1"  (June04 through June05). You want to normalize the case data in that range using the sales data for preceding months (in other words, the June05 complaint data should be normalized using the May05 sales data).

You would enter a period offset of "-1" to use the data for May05, because it is one period behind the reporting period.

 

Data

Field Description
Time Frame

This is the time frame that will be used for selecting data to appear on the report. It defaults to the same as the report time frame but does not have to be.

If the chart category is a date-type category, you must select time frames for the report. You do not need to fill out these fields if you have selected a category whose type is something other than a date.

For more detailed information on setting these values, refer to Time frames and Dates.

From Date

Select the starting date for the date range of the data to include on the report.

Thru

Select the ending date for the date range of the data to include on the report.

Value

This option determines how counting is done on the report. For information, refer to Report Values.

Results Language

Select the results language for the report.

Time Zone

Select the time zone to use when processing the report. This indicates the time zone to use when using dates on filters, displaying dates, and the dates used for calculating bucket counts.

If this field is blank, the dates will reflect the time zone of the user.

For category dates, only the system date time is updated for the time zone (Type J), all the other dates are shown as stored in the database.

Report Date Format

Select the format to use when displaying dates on the report. Choose from the following:

  • Blank or Use Date Format of Agent/System - first checks the agent's date format (set in the User Options) and if not defined, it uses the system date format (set in the System Parameters).
  • yyyy-MM-dd
  • dd-MMM-yyyy
  • dd/MM/yyyy
  • MM/dd/yyyy
Report Time Format

Select the format to use when displaying time on the report. Choose from the following:

  • Blank or Use Time Format of Agent/System - first checks the Agent's time format (set in the User Options) and if not defined it uses the System time format (set in the System Parameters).
  • Do not show Time
  • HH:mm:ss (24hr)
  • HH:mm (24hr)
  • hh:mmAM/PM
  • h:mmAM/PM

 

Report Filters

For information, refer to Filters in Emplifi Agent.

 

Related Topics Link IconRelated Topics