Connecting to Data


Uploading Data

You can upload, append, or merge delimited, Excel, JSON, or XML files to a target environment using WebFOCUS. Your file is initially loaded to a temporary environment, where you can modify and enhance your data before loading it to permanent storage.

Video: Creating Calculations

When you create a chart, you are not restricted to the fields that exist in your data source. You can create calculations from the data that exists to automate summations and other mathematical tasks related to your data fields. You can specify operators, fields, variables, and functions when creating a calculation. A calculation takes up no storage space in the data source, and is created only when needed.

You can create the following types of calculations:

Creating Circle Plot Charts

Use circle plot charts to display differing values in rows, enabling you to draw inferences as to how the values overlap.

Note: Circle plot charts require at least one measure and one dimension, as well as one for the Detail and Color buckets. Optionally, add a dimension to the Size bucket to view the concentration of data.

The following display options are available for a circle plot chart: