Page History
...
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
The formats are limited to the data type – For example the data type below is integer so only number based formats are permitted – such as currency, decimal, percentage or time stamp.
...
Details
Styleclass | ||
---|---|---|
| ||
| Common Format Options |
---|---|
Link To URL | Allows you to pass the value of the returned data into a URL link. Use the hashes ## to indicate to Yellowfin where you want the column value to be placed in the URL itself. For example: Formatting on a column of IP addresses and the URL typed in is: http://www.google.com.au/search?hl=en&q=##This essentially means that every IP address will be placed into it i.e.: http://www.google.com.au/search?hl=en&q=10.100.32.44 |
Org Reference Code | Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia
|
Raw Formatter | Displayed the data as it would have been returned from the database – no additional formatting applied. |
| Text |
Text | Displays as plain text |
Email Address | Creates a hyperlink on the text that will open an email client and pre-populate the sent to address. |
URL Hyperlink | Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL. |
Flag Formatter | If your data contains ISO country codes you can display these as flags of the world instead of text. |
| Date |
Date | Displays value as a date – multiple date options exist. |
Time | Displays value as a time field – multiple date options exist. |
Timestamp | Displayed full date and time value |
Date Part Formatter | Allows you display part of the date, e.g. Month Name, rather than the full date. |
Chart Granularity | Defines the default unit applied to this field when used in a time series chart. |
| Numeric |
Numeric | Displays value as a decimal – allows you to set the decimal places to be used. |
Percentage Bar | Converts a percentage value less than or equal to 100 into a bar. |
Additional Format Options
Styleclass | ||
---|---|---|
| ||
Option | Description |
---|---|
Table Name | This displays the name of the source table that the selected view field comes from. This is a read-only value. |
Column Name | This displays the name of the source column that the view field is based on. This is a read-only value. |
Display Name | This allows you to define the display name of the field, to be used in the report builder process. This can be overridden at the report level. |
Description | This allows you to provide a description for the column, to aid report writers' understanding of its purpose and contents. This will be displayed as a tooltip when a writer hovers over the field in the data step of the report builder, and will also be listed in the report information. |
Data Type | This displays the type of data contained within the source column. This is a read-only value. |
Converted Data Type | This displays the type of data contained within the field, after converters have been applied. This is a read-only value. |
Default Value | This displays the default value provided for a parameter field. This is a read-only value. |
Field Type | This displays the type of field, defined by Yellowfin, which specifies how the field can be used. This type can be changed on some fields, but is read-only on others. |
Date Field | This allows you to change the field the date function has been based on. This is only available on date function fields. |
Format
Styleclass | ||
---|---|---|
| ||
Option | Description | |
---|---|---|
Geometry Format | This allows you to specify the format of your native geometry field, define the order of lat and lon values in each point. | |
Cache Field | This allows you to select which field to cache the geometry data against. | |
Format | Each data type will have a unique set of format options – eg Text, Date or Numeric.
| |
Option | Description | |
Sub Format | Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option. | |
Date Other | If you select ‘Other’ from the date sub format you will be able to build your own custom date format. For example to create a Japanese date format which includes characters, eg.2003年4月2 日 would be created by adding in: yyyy年M月d 日 | |
Decimal Places | If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:
| |
Prefix | The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in: $ | |
Suffix | The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in: % | |
Rounding | The rounding format This allows you to choose define how a decimal the value of the field should be rounded. Panel | |
borderColor | white | bgColor | white
Thousand Separator | Turns the defaulted thousand separator for your instance on or off. For example: | 1000 to 1,000 |
Semi Additive Fields
Styleclass | ||
---|---|---|
| ||
The additive type option should be set to Semi-Additive when there are fields upon which the metric is constrained by use (when business rules dictate how the column should be used in a report). When this is the case a new tab labelled Constraint is displayed to enable the user to select these constraints.
See Constraints & Semi Additive Fields for more information
Default Aggregation
Styleclass | ||
---|---|---|
| ||
Bracket Negatives | This allows you to wrap negative values in brackets. |
Default Aggregation | When the field type is a metric you will be able to set the default aggregation (e.g. Sum, Average etc). This is used when adding the metric to a report it will automatically set the aggregation based on this default value. The options in the dropdown when the field type is a date are count, max and min. For all other field types the dropdown options are sum, average, count, max and min. |
...
|
...
|
...
Colour
Styleclass | ||
---|---|---|
| ||
Wiki Markup |
---|
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/8xO2P6VlpKU?color=white" frameborder="0" allowfullscreen></iframe>{html} |
When the field type is a metric you will be able to define a default colour to be applied in charts.
See Chart Formatting for more information on how to use Colour Sets.
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||
Colour | When the field type is a metric you will be able to define a default colour to be applied in charts.
|
Chart Granularity | Defines the default unit applied to this field when used in a time series chart. |
Filter Value Case | This allows you to specify if user prompt filter values entered by a user are converted automatically to upper or lowercase before being applied. |
Format Options
Based on the type of field that the column being formatted is there are various format options. The ones listed below come default with Yellowfin, however as this is customisable there may be additional ones that comes as part of your installation.
Common Format Options | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Link To URL | Allows you to pass the value of the returned data into a URL link. Use the hashes ## to indicate to Yellowfin where you want the column value to be placed in the URL itself.
For example: Formatting on a column of IP addresses and the URL typed in is: http://www.google.com.au/search?hl=en&q=##This essentially means that every IP address will be placed into it i.e.: | ||||||||||
Reference Code | Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia. This also allows for custom sorting, colours, and images to be applied.
| ||||||||||
Raw Formatter | Displayed the data as it would have been returned from the database – no additional formatting applied. | ||||||||||
Text | |||||||||||
Text | Displays as plain text. | ||||||||||
Case Formatter | Define if the value of the field should be converted to display as a specific case.
| ||||||||||
Creates a hyperlink on the text that will open an email client and pre-populate the sent to address. | |||||||||||
Flag Formatter | If your data contains ISO country codes you can display these as flags of the world instead of text. | ||||||||||
HTML Formatter | This allows you to format a field that contains HTML tags.
| ||||||||||
HTML 5 Video Formatter | This allows you to display video from a path stored in the field.
| ||||||||||
URL Hyperlink | Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL. | ||||||||||
YouTube Formatter | This allows you to display a YouTube video by using the value in the field as the video ID. | ||||||||||
Date | |||||||||||
Date | Displays value as a date – multiple date options exist.
| ||||||||||
Time | Displays value as a time field – multiple date options exist. | ||||||||||
Timestamp | Displayed full date and time value | ||||||||||
Date Part Formatter | Allows you display part of the date, e.g. Month Name, rather than the full date.
| ||||||||||
Numeric | |||||||||||
Numeric | Displays value as a decimal – allows you to set the decimal places to be used. | ||||||||||
Percentage Bar | Converts a percentage value less than or equal to 100 into a bar. | ||||||||||
Geometry | |||||||||||
Default Geometry | |||||||||||
Geometry |
|
Access
Styleclass | ||
---|---|---|
| ||
Option | Description |
---|---|
Access Filter | |
Access Level | |
Field Permissions | |
Mandatory Field | |
Mandatory Filter |
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||