ACE Analytics Creating Charts and Gauges

Click the Add Chart tab to use the feature that lets you create charts and gauges. A separate Chart panel with its own configuration area will be displayed:

Here's how to use this feature:

1. Click the option item for the type of chart to be created. Specific controls will be displayed, depending on the selected type.
2. Assuming a Bar chart was selected, select the Label Column. This provides data for the X-axis of the chart. If the column selected is a date-type column, an interval control (Year, Quarter, Month, Day) will be displayed.
3. Select the Data Column (Y-axis data, the "height" of each bar). You'll see that the options are grouped and color-coded to make it easier for you to identify them. If you created any Formula columns, they'll be in there, too. You can also choose to show the actual data values on the chart.
4. Select a Data Aggregation function. Options include: Sum, Average, Standard Deviation, Count, Distinct Count, Minimum, and Maximum. Columns with Null values are excluded by default from aggregations. However, your ACE Analytics application may be configured to include them; check with the developer of your application for details.
5. The Comparison Column specifies a second data series that will be charted along with the Data Column values for comparison. Depending on the chart type, an option will appear to control how this second series appears. For Bar charts, options include Stacked, Stacked Percentage and Side By Side.
6. Data Forecasting is available for Bar, Line, and Curved Line charts. See the section below for more information.
7. Bar Orientation allows you to choose whether the bars are vertical or horizontal.

Depending on how your application is configured, you may see an "OK" button that applies all of your selection changes to the chart at once. Otherwise, your chart will be redrawn immediately as you make individual changes.

Hide the chart configuration area by clicking the Gear icon, or delete the chart entirely by clicking the Trashcan icon.

Charts are displayed in their own panels, so you can expand and collapse them using their "+" and "-" icons. You can also rearrange the order of chart and table panels by clicking with your mouse near the top of a panel, and dragging it up or down.

Charts will automatically include Quicktips, which appear when you hover your mouse over a data value, as shown above. In addition, "resizing handles" (circled above) will appear when the mouse is over the chart, allowing you to resize the chart by dragging them.

Unlike the chart shown above, Bar charts that are not time-oriented will automatically be shown in a horizontal format. This allows greater clarity in reading the "X-axis" label text.

Data Forecasting

Data Forecasting, if included by your application developer, is available for Bar, Line, and Curved Line charts.

If it's available, extra controls for it will appear in the Chart configuration panel, as shown above.

Data forecasting is the process of generating values based on events that have not yet occurred. "Prediction" is a similar but more general term. Forecasting refers to formal, statistical methods that use time series, cross-sectional, or longitudinal data to produce predicted data. Typically, forecasts are displayed most effectively on charts.

Forecasting analysis options include:

• Time Series (Time Series Decomposition), consisting of data in a natural, time-related order with a strong interval, where the Label Column data is of DateTime-type and the Data Column is a number.
• Regression, using one of several regression analysis functions. Regression analysis is recommended when the focus is on a relationship between a dependent value and one or more independent values. Available analysis functions include:
  • Linear - used to calculate predictive values based on a trend line.
  • Autoregressive - used when attempting to predict an output of a system based on previous outputs. The estimation technique used is based on "Burg's" method.
  • Exponential, Logarithmic, Polynomial, or Power - non-linear types used to display the relationship between dependent and independent variables as a curvilinear function, which may provide more accuracy than a linear regression.

More information about forecasting with Info can be found in our Forecasting Elements document.

Click the Gear icon to hide the configuration area.