Page History

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. Click here for additional settings related to this formatter.

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.

Email

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:
<img src="http://imagepathhere.png" />.

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.
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:

This essentially means that every ip address will be placed into it 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. See Reference Codes for more information.

Allows you to create a single sparkline column or column charts chart within the report table. Click here for additional settings related to this formatter.

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

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

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.