Page History
...
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
...
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.
Format Option | Description |
---|---|
Text | Displays as plain text. |
Action button | Allows you to create an action button linked to a URL. You can pass the value of the returned data into a URL link. Use double hashes ## to indicate where you want the column value to be placed in the url itself. For example, the system will replace the ## in the following link with the column value, and initiate a Google search on it. http://www.google.com.au/search?hl=en&q=## Note: This formatter is similar to the ‘Link to URL’ formatter. |
Case Formatter | Allows you to format text as Uppercase or Lowercase. |
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 | Formats a field containing HTML tags, either by removing them, or using them, depending on user selection. For example, if you wanted to display an image using a URL the field may look something like this: |
HTML 5 Video | Displays a video from a path stored in the field, either a full URL, or a relative path if the video is stored in the Yellowfin ROOT directory. |
Link To URL | Allows you to pass the value of the returned data into a URL link. This essentially means that every ip address will be placed into it into it i.e.: http://www.google.com.au/search?hl=en&q=10.100.32.44 |
Reference Code | Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia. See Reference Codes for more information. |
Sparkline Formatter | Allows you to create sparkline or column charts within the report table. Tip: You may use this in conjunction with the Sparkline Array advanced function, or any text field that contains comma separated numeric values. For example, you may create a calculated field with multiple values gathered from different metrics or dimensions to create a sparkline chart, as long as they are comma separated. |
Raw Formatter | Displayed the data as it would have been returned from the database – no additional formatting applied. |
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 displays a YouTube video, based on the ID being stored in the field. |
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 | Takes a date field and formats the display to show part of that 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. |
...
Column Drop Down Menu
Styleclass | ||
---|---|---|
| ||
...