...
Expand |
---|
title | Click to Expand Details |
---|
|
Section |
---|
Column |
---|
| ![](https://yellowfinjp.atlassian.net/wiki/download/attachments/2326808/11dropdownmenu.png?version=1&modificationDate=1409861182998&cacheVersion=1&api=v2)
|
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. |
---|
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} |
|
|
|
Column Formatting
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.
...