You can use the Calculator to perform basic calculations on fields in your data hierarchy. When you create a calculated field, a new, unique field is created. It incorporates all of the data fields and expressions that you added to the calculation.
As you create charts or styled tabular content in WebFOCUS Designer, you may want narrow the display of information that is shown. You can do this by creating filters with data fields in your content. You can also use filters as a way to create custom displays of the data that you show in your content. For example, you may only want to show revenue information for specific product categories and models in a given year.
Changing the display or output format of measure fields that have been placed on the canvas or in field containers allows you to control how values in a field are interpreted and the styling that they use when displayed. This feature allows for field display formatting, which is essential for any data-based content design tool.
A data grid is a type of chart that displays a tabular representation of your data, similar in structure to a tabular report. A data grid allows you to review data in a row and column format, similar to a printed report. Data grids are easy to create, and provide features such as a tooltip for each cell of the grid. WebFOCUS Designer provides numerous options to style and format a data grid.
Values in a data grid can be sorted, and data grids can be shared or saved for use on a page. A data grid is shown in the following image.
If you are working with a chart type that supports a matrix format (for example, Matrix Marker), WebFOCUS Designer provides a selection of formatting options that you can use to customize and enhance the styling of your chart. A matrix format is a grid that contains values based on the intersecting data points, which is useful for reviewing changes and trends over time. Available formatting options for matrix charts include Headers and labels, and Lines, as shown in the following image.
A series, which is a set of data, represents the set of values for one field in the request (for example, a measure). These numbers are plotted in a chart. You can format the series in your chart, which includes font formatting, display options for labels, and other options, including the ability to hide overlapping labels. Using the Series options, you can select a specific series in a chart to which to apply changes, or you can select All Series, which applies changes to all series in the chart.
In a chart, the legend identifies values according to the color-coded data values that display. The legend typically displays on the right side of the chart, but you can change the location using the formatting options available for legends. You can format a legend in any of the following ways:
You can use headers and footers to add key information, such as purpose of the chart and the audience. For example, if you have gross profit for different product categories, you can add a header to highlight this information in your chart.
You can add multiple lines of information into the heading and footing areas in a chart. This accommodates thorough explanations and additional information while offering the most readable presentation.
As you work with your chart, you can make modifications that improve the display of your chart, highlighting the layout and presentation of the chart components. Some of the formatting options include:
Charts allow you to present information graphically, using such visual cues as color, size, and position to convey relationships between measures (numeric fields to be aggregated) and dimensions (categories) and to identify trends and outliers. You can create a wide variety of charts. For example, you can review your data (Gross Profit and Product Category) using different chart types (for example, bar chart, area chart, or line chart). The chart options give you an edge in deciding which chart to use.
