Show Calculations Property
In the Key Browser, the Show Calculations property will add several aggregates to each key. These allow your reports to easily display things like the total of a key. These calculations are typically used in the summary row on the Table component.
Once Show Calculations is enabled, the Key Browser will refresh, and each key will be expandable. Expanding a key will show the available calculations.
Show Calculations Disabled
Show Calculations Enabled
Calculation Keys work like any other key: they may be dragged onto the report, and utilized in keychain expressions.
Data Key Usage
Data Keys as Paths
Data Keys are relative, and use 'dot notation' to reference children. Meaning, if we have a nested data structure, we can use Data Key paths (also known as Keychains) to reference the nested data. In the key browser image below, we have a nested data source called Downtime. Downtime contains a number of columns, and then contains a reference to additional data called
runInfo. If we wanted to access the highlighted
operator data, we could use the keychain dot notation in the Designer - @Downtime.runInfo.operator@. Nested datasources are outside the scope of this page, but you can learn about Datasource nesting in the Nested Queries section.
Array Index of Data
You can reference an individual object in a list using standard array indexing syntax (brackets) like this:
@Data.firstName@, where Data is a data source that contains a child data key named
firstName. In this case, we would be accessing the first