Page History
...
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. |
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. 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 | ||||
---|---|---|---|---|
|
Action button formatter settings
Below are descriptions of all settings used to configure action buttons in reports.
Option | Description |
---|---|
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 | ||||
---|---|---|---|---|
|
Sparkline formatter settings
Below are descriptions of all settings for the Sparkline formatter.
Option | Description |
---|---|
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 | ||
---|---|---|
| ||
...