Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

http://www.google.com.au/search?hl=en&q=##

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

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.

Anchor
actionbuttonformatter
actionbuttonformatter

Action button formatter settings

Below are descriptions of all settings used to configure action buttons in reports.

OptionDescription

URL

Define the URL to use, including ## to be replaced by the field value. You can also reference other columns of data in the table by using the {{1}} syntax, where ‘1’ is the position of the column appearing in the report table. Note that the position numbering starts from‘1’ rather than ‘0’.

URL type

Specify whether the URL points to something external (Remote) or internal (Local) in the system.

New window

Allows you to open the URL in a new browser window when enabled.

Button display text

Enter the text to be displayed on the action button.

Disable button on click

Specify whether the button should be disabled or not when clicked.

Use data values to disable button

The button will become disabled by specified data values in a given column.

Status field

Enter the column number from disabled values will be sourced.

Disabled values

No action button will be displayed for these values, a completed status button will be displayed instead.

Inactive display

Choose how the button should be displayed for inactive status. You can choose to display a blank cell, a success icon, or an inactive button.


Anchor
sparklineformatter
sparklineformatter

Sparkline formatter settings

Below are descriptions of all settings for the Sparkline formatter.

OptionDescription

Width

Specify the maximum width of the sparkline chart.

Height

Specify the maximum height of the sparkline chart.

Sparkline type

Select whether the chart should be displayed as a sparkline or a column.

Includes scaling value

Enables scaling on the chart. Scaling enables the chart to scale lines by observing values of all rows. If left unscaled, a sparkline with smaller values, such as 10, 21, 35, and so on, might look similar to a sparkline with drastically different values that have similar value differences, such as 100, 210, 350, and so on.

If enabled, the first data-point will be treated as a scaling value, and will not be rendered.



...

Column Drop Down Menu

Styleclass
ClasstopLink

top

...