Versions Compared

Key

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

...

Expand
titleClick to Expand Details
Section
Column
width3%

Column
width97%

Convert to Text Field

This allows the contents of the field to be treated as text, changing the functionality that's available to it from numeric or date to text. This option is only displayed on fields not recognised as text natively.

Field Type

This allows you to change the field from a Metric to a Dimension or Geography, or from a Dimension to Geography. See Geography Fields for more information.

Expand
titleSee Video...
Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/b6GoymGxwl0?color=white" frameborder="0" allowfullscreen></iframe>{html}

Index

This allows you to add an index to the field in order to increase read performance. Generally, indexes should be added to fields that will be used in joins or filters.

Drill To

This allows you to define a Dimension field to Drill Down to.

Format

This opens the Column Formatting menu, allowing you to apply default formatting options and apply meta data to the field.

Default Aggregation

This allows you to assign a default aggregation to be applied to the Metric field when added to reports. This can be overridden in the Report Builder.

Copy

This allows you to create a duplicate copy of the field, which can then be formatted, converted, or changed separately to the original.

Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/IlLAsdamStQ?color=white" frameborder="0" allowfullscreen></iframe>{html}

...

Defining field meta data and formatting is an important part of View creation and as such, an important part of the CSV import process. The Column Formatting menu provides you with a range of options depending on the field type.

See Field Format フィールド書式 for more information.

Security

...

Expand
titleClick to Expand Details

Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/fFQOyrU4XPI?color=white" frameborder="0" allowfullscreen></iframe>{html}

Formula Builder

This allows you to create calculations using either the Calculated Field option, or the Grouped Values option.

Formula Templates

This allows you to create advanced calculations based on Pre-Defined Formulas.

Date Conversion

This allows you to convert a non-standard format date field (one Yellowfin doesn't recognise as a date by default) to a recognised date/time field, by specifying its format.
See Date Conversion 日付変換 for more information.

Timestamp Conversion

This allows you to convert values stored in Java time format (milliseconds since midnight January 1, 1970, GMT) to timestamps.

Numeric Conversion

This allows you to convert fields recognised as text by Yellowfin, that contain numeric values, to numeric fields.

...