Visualizing Data

Changing the Size of Charts and Risers

By default, when you create a chart, it fills the frame in which it is run, and risers and other sections within the chart are sized accordingly. This makes the chart flexible, allowing it to run in large and small containers alike without sacrificing the appearance and legibility of the chart. This automatic sizing also means that you do not need to manually set any size properties for the chart.

Video: How to Style Reports in TIBCO WebFOCUS® Designer

You can style the text and cells of different areas of a report to visually highlight or separate different groups of values, such as columns, column headers, across field values, and totals, in order to call attention to certain information in a report.

Enabling Drill Anywhere to Analyze Field Relationships

Auto Drill is a feature that allows you to drill into values from fields that are part of a data hierarchy, to see which subcategories within that hierarchy contribute to the values that you drill into, and to what extent. Drill Anywhere, meanwhile, resembles an enhanced version of Auto Drill. It does not require the fields in your initial content to be part of a data hierarchy, and it allows you to drill to any field in your data source, providing a powerful tool to explore relationships between values in different fields.

Setting Conditional Styling Based on Data Values

Conditional styling is a feature that applies unique styling to cells in a chart or report when their values meet specified criteria. This allows you to highlight values that are especially high or low, or are higher and lower than those in another field, making it easy to spot important information in your content. You can even use conditional styling to add drill down links to values that match your set criteria, allowing users who run the chart or report to access additional context and information pertaining to those records.

Working With Toggle Controls

In some cases, instead of having a list of several possible filter values, you may want to create a filter in which only two values are available. Sometimes, this will be a Boolean expression, in which a pre-defined flag can be set to true or false. At other times, you may have a field that has only two available values, and you may want only one or the other to be available at a given time. In each of these cases, a toggle control can be a straightforward way to present these filters. The toggle control is available in pages assembled from existing content items.

Working With Double List Controls

Another common type of control for alphanumeric fields is a double list control. You can select items in the full list of values on the left, and add them to the list of selected values on the right. The double list control also includes the option to reorder the selected values. This can be especially useful when using multi-select field list parameters in an InfoApp, allowing you to change the order of sort and measure fields in the parameterized content.

Enabling Field Selection at Run Time With Field List Parameters

Field list parameters are a powerful tool that allows you to provide users with a selection of fields that they can use at run-time to build charts and reports within a framework that you provide. Field list parameters can be added to buckets in place of fields in a chart or report. At run time, users select the fields that they want to display, giving them the power to choose the data that is represented by and displayed in your content. You can complement these field list parameters with fields that always appear in your content, providing a mix of customizable and static content.

Filtering Large or Streaming Data Sources

By default, the filter controls that you create in WebFOCUS Designer include, or are bounded based on, a list of values from your data source, which allows you to more easily select valid values from these controls. However, when working with large or streaming data sources, it may not be prudent to query the data source to retrieve this list, as a large number of values may exceed the maximum that can display in the filter control, or cause performance issues, while values from streaming data sources may change rapidly.

Setting Page Layout Options

When creating reports for different types of output, you may want to change the page layout, depending on the type of file that will be generated. For example, PowerPoint slides are typically landscape oriented, and a smaller size than PDF pages, which tend to be vertically oriented. You can set options such as page orientation, page size, and margins, separately for each output format, by selecting Output Settings from the quick access menu on the Format tab.