...
Expand |
---|
title | Click to Expand Details |
---|
|
Section |
---|
Column |
---|
|
|
Column |
---|
| 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 |
---|
| 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 |
---|
title | Click 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. |
---|
|
...