Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
|
...
...
Yellowfin comes with a set of pre-defined functions. However, your administrator may add in additional functions specifically for your organisation or reporting needs. Expand the following to see the lists of functions available:
Expand | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
|
Expand | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Expand | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
Data Conversion allows you to adjust results once they've returned from the database. For example you may wish to convert a currency value which is stored in the database from a full currency value to a (‘000) where the value is divided by 1000. This transformation can be achieved using the data conversion. |
Applying a Function
Styleclass | ||
---|---|---|
|
...
Report Builder - Data Step
...
- Open the field's drop down menu
- Now select the Advanced Function option from the list, opening the Advanced Function display.
- You will now need to complete the function options:
- Apply the appropriate aggregation to the field. This ensures the function is applied on top of any aggregations necessary.
- Select which function type you wish to use, from Analysis, Statistical, and Text
- Select the name of the function you wish to use from the list. Once selected, you will see a description of the function displayed next to it. Some functions require extra parameters, which will need to be defined once the function has been selected.
- You also have the option to set the function to only display on the Charts page. This allows you to create additional copies of a field to apply functions to for graphical purposes, without cluttering your table with extra fields.
- When defined, click Save to apply the function.
Applying Data Conversion
Styleclass | ||
---|---|---|
|
...
- Open the Advanced Function display, as outlined in the sections above.
- Choose the ‘Data Conversion’ tab. This will provide you with the interface to use to select the conversion you wish to apply.
- Choose the aggregation appropriate for you conversion.
- Click Add button to select and apply a conversion – this will present you with a list of possible conversions for the data type you have selected. By default there is a java date converter and a Numeric divide converter (This lets you divide a value by 1000’s etc).
- Follow the on screen instructions for the converter and click Save.
- Note that you can add multiple converters to a data type if required by clicking the add link and creating a new type.
horizontalrule |
---|
Styleclass | ||
---|---|---|
|
...