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.

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.