| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
Overview
With Yellowfin’s view builder you can create derived columns based on the fields sourced from the database. These calculations can include simple mathematical calculations or more complex SQL statements.
You can create a number of different types of calculated columns including:
Type | Description |
|---|---|
This allows you to build calculations through a builder interface, rather than having to write the SQL yourself. | |
This allows you to create a field that returns grouped results. | |
This allows you to define filters for Report Writers to use, rather than defining them for each report. | |
This allows you to define a field that can have its value defined by a Report Reader and then passed into the report for What If analysis. | |
This allows you to create a set of fields to be used as filters in reports. This can include filter dependencies and cached values. | |
This allows you to build a calculation by writing the SQL, rather than using a builder. | |
This allows you to build a calculation using a template, rather than having to use a builder, simply by specifying the fields it requires. | |
This allows you to create a time based hierarchy by converting date fields into various formats to create each level. |
Create New Column
You can create new calculated fields within your view as required.
...
...
概要